import warnings
import numpy as np #Exploratory Data Analysis
import pyspark.pandas as ps
import seaborn as sns
import matplotlib.pyplot as plt
import plotly.graph_objects as go
from plotly.offline import iplot
from random import random
from pyspark.ml import Pipeline #Modeling
from pyspark.ml.regression import LinearRegression, DecisionTreeRegressor, RandomForestRegressor, GBTRegressor
from pyspark.ml.feature import VectorAssembler
from pyspark.ml.evaluation import RegressionEvaluator
import mlflow #Deployment
import mlflow.sklearn
import mlflow.azureml
import azureml
from azureml.core import Workspace
from azureml.core.authentication import InteractiveLoginAuthentication
from sklearn.model_selection import train_test_split
from sklearn.ensemble import GradientBoostingRegressor
from sklearn.metrics import mean_squared_error, mean_absolute_error, r2_score
dbutils.fs.mount(
source = "wasbs://dataset@pricedatastorage.blob.core.windows.net",
mount_point = "/mnt/data",
extra_configs = {"fs.azure.account.key.pricedatastorage.blob.core.windows.net":"UUpMhyQ6jNC4fFy2QbYKaomV+hJAXB3P1oSxDP9jQyXIpBc1ljzZb4wAZQ4U7eyTYphlEHso+4tj+AStbx1GPQ=="})
Import the dataset
df = spark.read.csv('/mnt/data/train.csv',inferSchema=True,header=True)
test_df = spark.read.csv('/mnt/data/test.csv',inferSchema=True,header=True)
Convert spark dataframe into pandas dataframe
df = df.to_pandas_on_spark()
df = df.to_pandas()
test_df = test_df.to_pandas_on_spark()
test_df = test_df.to_pandas()
df.display()
| key | fare_amount | pickup_datetime | pickup_longitude | pickup_latitude | dropoff_longitude | dropoff_latitude | passenger_count |
|---|---|---|---|---|---|---|---|
| 2009-06-15T17:26:21.000+0000 | 4.5 | 2009-06-15T17:26:21.000+0000 | -73.844311 | 40.721319 | -73.84161 | 40.712278 | 1 |
| 2010-01-05T16:52:16.000+0000 | 16.9 | 2010-01-05T16:52:16.000+0000 | -74.016048 | 40.711303 | -73.979268 | 40.782004 | 1 |
| 2011-08-18T00:35:00.000+0000 | 5.7 | 2011-08-18T00:35:00.000+0000 | -73.982738 | 40.76127 | -73.991242 | 40.750562 | 2 |
| 2012-04-21T04:30:42.000+0000 | 7.7 | 2012-04-21T04:30:42.000+0000 | -73.98713 | 40.733143 | -73.991567 | 40.758092 | 1 |
| 2010-03-09T07:51:00.000+0000 | 5.3 | 2010-03-09T07:51:00.000+0000 | -73.968095 | 40.768008 | -73.956655 | 40.783762 | 1 |
| 2011-01-06T09:50:45.000+0000 | 12.1 | 2011-01-06T09:50:45.000+0000 | -74.000964 | 40.73163 | -73.972892 | 40.758233 | 1 |
| 2012-11-20T20:35:00.000+0000 | 7.5 | 2012-11-20T20:35:00.000+0000 | -73.980002 | 40.751662 | -73.973802 | 40.764842 | 1 |
| 2012-01-04T17:22:00.000+0000 | 16.5 | 2012-01-04T17:22:00.000+0000 | -73.9513 | 40.774138 | -73.990095 | 40.751048 | 1 |
| 2012-12-03T13:10:00.000+0000 | 9.0 | 2012-12-03T13:10:00.000+0000 | -74.006462 | 40.726713 | -73.993078 | 40.731628 | 1 |
| 2009-09-02T01:11:00.000+0000 | 8.9 | 2009-09-02T01:11:00.000+0000 | -73.980658 | 40.733873 | -73.99154 | 40.758138 | 2 |
| 2012-04-08T07:30:50.000+0000 | 5.3 | 2012-04-08T07:30:50.000+0000 | -73.996335 | 40.737142 | -73.980721 | 40.733559 | 1 |
| 2012-12-24T11:24:00.000+0000 | 5.5 | 2012-12-24T11:24:00.000+0000 | 0.0 | 0.0 | 0.0 | 0.0 | 3 |
| 2009-11-06T01:04:03.000+0000 | 4.1 | 2009-11-06T01:04:03.000+0000 | -73.991601 | 40.744712 | -73.983081 | 40.744682 | 2 |
| 2013-07-02T19:54:00.000+0000 | 7.0 | 2013-07-02T19:54:00.000+0000 | -74.00536 | 40.728867 | -74.008913 | 40.710907 | 1 |
| 2011-04-05T17:11:05.000+0000 | 7.7 | 2011-04-05T17:11:05.000+0000 | -74.001821 | 40.737547 | -73.99806 | 40.722788 | 2 |
| 2013-11-23T12:57:00.000+0000 | 5.0 | 2013-11-23T12:57:00.000+0000 | 0.0 | 0.0 | 0.0 | 0.0 | 1 |
| 2014-02-19T07:22:00.000+0000 | 12.5 | 2014-02-19T07:22:00.000+0000 | -73.98643 | 40.760465 | -73.98899 | 40.737075 | 1 |
| 2009-07-22T16:08:00.000+0000 | 5.3 | 2009-07-22T16:08:00.000+0000 | -73.98106 | 40.73769 | -73.994177 | 40.728412 | 1 |
| 2010-07-07T14:52:00.000+0000 | 5.3 | 2010-07-07T14:52:00.000+0000 | -73.969505 | 40.784843 | -73.958732 | 40.783357 | 1 |
| 2014-12-06T20:36:22.000+0000 | 4.0 | 2014-12-06T20:36:22.000+0000 | -73.979815 | 40.751902 | -73.979446 | 40.755481 | 1 |
| 2010-09-07T13:18:00.000+0000 | 10.5 | 2010-09-07T13:18:00.000+0000 | -73.985382 | 40.747858 | -73.978377 | 40.76207 | 1 |
| 2013-02-12T12:15:46.000+0000 | 11.5 | 2013-02-12T12:15:46.000+0000 | -73.957954 | 40.779252 | -73.96125 | 40.758787 | 1 |
| 2009-08-06T18:17:23.000+0000 | 4.5 | 2009-08-06T18:17:23.000+0000 | -73.991707 | 40.770505 | -73.985459 | 40.763671 | 1 |
| 2010-12-06T12:29:00.000+0000 | 4.9 | 2010-12-06T12:29:00.000+0000 | -74.000632 | 40.747473 | -73.986672 | 40.740577 | 1 |
| 2009-12-10T15:37:00.000+0000 | 6.1 | 2009-12-10T15:37:00.000+0000 | -73.969622 | 40.756973 | -73.981152 | 40.759712 | 1 |
| 2011-06-21T16:15:00.000+0000 | 7.3 | 2011-06-21T16:15:00.000+0000 | -73.991875 | 40.754437 | -73.97723 | 40.774323 | 3 |
| 2011-02-07T20:01:00.000+0000 | 6.5 | 2011-02-07T20:01:00.000+0000 | 0.0 | 0.0 | 0.0 | 0.0 | 1 |
| 2011-06-28T19:47:00.000+0000 | 4.5 | 2011-06-28T19:47:00.000+0000 | -73.988893 | 40.76016 | -73.986445 | 40.757857 | 3 |
| 2012-05-04T06:11:20.000+0000 | 9.3 | 2012-05-04T06:11:20.000+0000 | -73.989258 | 40.690835 | -74.004133 | 40.72569 | 1 |
| 2013-08-11T00:52:00.000+0000 | 4.5 | 2013-08-11T00:52:00.000+0000 | -73.98102 | 40.73776 | -73.980668 | 40.730497 | 2 |
| 2014-02-19T16:03:00.000+0000 | 5.5 | 2014-02-19T16:03:00.000+0000 | -73.976075 | 40.752422 | -73.981082 | 40.759285 | 1 |
| 2015-06-21T21:46:34.000+0000 | 22.54 | 2015-06-21T21:46:34.000+0000 | -74.01048278808595 | 40.71766662597656 | -73.98577117919923 | 40.66036605834961 | 1 |
| 2009-01-09T16:10:00.000+0000 | 31.9 | 2009-01-09T16:10:00.000+0000 | -73.873027 | 40.773883 | -73.984545 | 40.769545 | 3 |
| 2011-09-07T14:05:00.000+0000 | 5.7 | 2011-09-07T14:05:00.000+0000 | -73.976162 | 40.744988 | -73.990002 | 40.738323 | 2 |
| 2011-09-07T23:05:44.000+0000 | 18.1 | 2011-09-07T23:05:44.000+0000 | -73.993717 | 40.740785 | -73.999272 | 40.676617 | 1 |
| 2015-01-11T03:15:38.000+0000 | 58.0 | 2015-01-11T03:15:38.000+0000 | -73.98332977294923 | 40.73871994018555 | -73.93319702148438 | 40.84722518920898 | 1 |
| 2015-03-12T08:08:38.000+0000 | 4.5 | 2015-03-12T08:08:38.000+0000 | -73.99017333984375 | 40.756446838378906 | -73.9856185913086 | 40.7628288269043 | 1 |
| 2012-01-19T10:15:30.000+0000 | 5.3 | 2012-01-19T10:15:30.000+0000 | -73.995199 | 40.75474 | -74.005416 | 40.751084 | 1 |
| 2013-11-24T11:42:00.000+0000 | 9.0 | 2013-11-24T11:42:00.000+0000 | -73.95774 | 40.773617 | -73.977087 | 40.758465 | 6 |
| 2009-03-02T20:42:49.000+0000 | 9.8 | 2009-03-02T20:42:49.000+0000 | -73.972673 | 40.759186 | -73.969897 | 40.791367 | 1 |
| 2011-03-29T15:39:49.000+0000 | 8.1 | 2011-03-29T15:39:49.000+0000 | -73.984267 | 40.744961 | -73.981646 | 40.759608 | 1 |
| 2011-10-15T10:55:24.000+0000 | 10.9 | 2011-10-15T10:55:24.000+0000 | -74.003899 | 40.725514 | -73.976484 | 40.765537 | 2 |
| 2013-11-22T08:38:09.000+0000 | 17.5 | 2013-11-22T08:38:09.000+0000 | -73.97845 | 40.76292 | -74.008482 | 40.716502 | 1 |
| 2009-06-10T21:28:00.000+0000 | 12.1 | 2009-06-10T21:28:00.000+0000 | -73.988558 | 40.7372 | -73.958688 | 40.780748 | 1 |
| 2011-03-04T18:12:00.000+0000 | 5.3 | 2011-03-04T18:12:00.000+0000 | -73.997037 | 40.737095 | -73.986128 | 40.735043 | 1 |
| 2011-08-31T21:14:15.000+0000 | 6.9 | 2011-08-31T21:14:15.000+0000 | -73.971114 | 40.758944 | -73.97793 | 40.736613 | 1 |
| 2011-06-01T20:30:00.000+0000 | 4.5 | 2011-06-01T20:30:00.000+0000 | -73.980822 | 40.74442 | -73.991093 | 40.748797 | 1 |
| 2011-12-14T07:53:00.000+0000 | 3.3 | 2011-12-14T07:53:00.000+0000 | -73.988877 | 40.763577 | -73.985573 | 40.760262 | 1 |
| 2012-07-18T00:16:00.000+0000 | 3.3 | 2012-07-18T00:16:00.000+0000 | -73.98666 | 40.756072 | -73.989727 | 40.751702 | 5 |
| 2013-01-29T12:26:00.000+0000 | 9.0 | 2013-01-29T12:26:00.000+0000 | -73.992253 | 40.742657 | -73.983597 | 40.755947 | 1 |
| 2011-12-06T09:09:21.000+0000 | 9.7 | 2011-12-06T09:09:21.000+0000 | -73.985582 | 40.739765 | -73.973899 | 40.760426 | 1 |
| 2012-10-06T20:31:36.000+0000 | 5.5 | 2012-10-06T20:31:36.000+0000 | -73.952825 | 40.772048 | -73.952194 | 40.781152 | 3 |
| 2013-01-23T07:01:38.000+0000 | 8.0 | 2013-01-23T07:01:38.000+0000 | -73.980298 | 40.783723 | -73.979628 | 40.763179 | 1 |
| 2013-09-07T03:17:00.000+0000 | 7.5 | 2013-09-07T03:17:00.000+0000 | -73.977708 | 40.746212 | -73.975782 | 40.745055 | 1 |
| 2013-11-10T01:12:19.000+0000 | 25.5 | 2013-11-10T01:12:19.000+0000 | -73.974497 | 40.751603 | -73.934927 | 40.851567 | 4 |
| 2012-01-04T18:07:29.000+0000 | 15.3 | 2012-01-04T18:07:29.000+0000 | -73.97151 | 40.755886 | -73.968067 | 40.801173 | 1 |
| 2010-05-31T18:06:00.000+0000 | 34.67 | 2010-05-31T18:06:00.000+0000 | -73.985427 | 40.758853 | -73.872907 | 40.774497 | 1 |
| 2011-03-19T21:55:00.000+0000 | 9.7 | 2011-03-19T21:55:00.000+0000 | -73.979542 | 40.727498 | -73.999315 | 40.730088 | 4 |
| 2012-07-19T23:53:14.000+0000 | 13.7 | 2012-07-19T23:53:14.000+0000 | -74.002113 | 40.739582 | -73.971918 | 40.791899 | 2 |
| 2009-03-23T12:13:29.000+0000 | 6.5 | 2009-03-23T12:13:29.000+0000 | -73.98543 | 40.736011 | -73.982501 | 40.724802 | 1 |
| 2014-07-16T10:57:00.000+0000 | 5.0 | 2014-07-16T10:57:00.000+0000 | -73.996148 | 40.74189 | -73.992202 | 40.739425 | 6 |
| 2011-04-22T23:21:03.000+0000 | 4.5 | 2011-04-22T23:21:03.000+0000 | -74.009137 | 40.713436 | -74.002823 | 40.723428 | 3 |
| 2012-01-02T14:54:00.000+0000 | 4.9 | 2012-01-02T14:54:00.000+0000 | -74.003985 | 40.731677 | -73.999765 | 40.723512 | 1 |
| 2014-05-01T09:12:00.000+0000 | 7.0 | 2014-05-01T09:12:00.000+0000 | -73.966203 | 40.7675 | -73.980915 | 40.77424 | 6 |
| 2011-11-07T10:47:40.000+0000 | 7.3 | 2011-11-07T10:47:40.000+0000 | -74.003919 | 40.753019 | -73.992368 | 40.735362 | 1 |
| 2012-10-07T17:59:08.000+0000 | 7.5 | 2012-10-07T17:59:08.000+0000 | -74.004736 | 40.715882 | -74.017723 | 40.705141 | 1 |
| 2014-01-17T09:03:00.000+0000 | 8.5 | 2014-01-17T09:03:00.000+0000 | -73.991467 | 40.750575 | -73.98575 | 40.741547 | 4 |
| 2014-04-29T18:28:00.000+0000 | 16.5 | 2014-04-29T18:28:00.000+0000 | -73.970323 | 40.75084 | -73.998392 | 40.724862 | 6 |
| 2015-04-12T10:19:05.000+0000 | 11.5 | 2015-04-12T10:19:05.000+0000 | -73.97927856445312 | 40.723438262939446 | -74.00460815429686 | 40.7469482421875 | 6 |
| 2015-05-12T23:51:42.000+0000 | 5.0 | 2015-05-12T23:51:42.000+0000 | -73.95479583740233 | 40.779335021972656 | -73.94493103027344 | 40.780086517333984 | 1 |
| 2009-08-02T02:34:11.000+0000 | 6.9 | 2009-08-02T02:34:11.000+0000 | -73.995781 | 40.723411 | -74.005004 | 40.71895 | 2 |
| 2010-01-31T10:53:00.000+0000 | 3.7 | 2010-01-31T10:53:00.000+0000 | -74.00163 | 40.730767 | -73.997112 | 40.737533 | 1 |
| 2010-05-14T08:09:00.000+0000 | 6.9 | 2010-05-14T08:09:00.000+0000 | -73.955118 | 40.768942 | -73.963495 | 40.761887 | 2 |
| 2012-05-21T15:20:00.000+0000 | 10.1 | 2012-05-21T15:20:00.000+0000 | -73.977788 | 40.771838 | -73.9662 | 40.778113 | 2 |
| 2014-12-08T16:00:01.000+0000 | 16.5 | 2014-12-08T16:00:01.000+0000 | -73.9828 | 40.745287 | -74.01425 | 40.702935 | 1 |
| 2010-08-16T01:33:00.000+0000 | 15.07 | 2010-08-16T01:33:00.000+0000 | -73.961933 | 40.795585 | -73.962253 | 40.764817 | 2 |
| 2010-12-04T14:26:13.000+0000 | 7.7 | 2010-12-04T14:26:13.000+0000 | -73.996601 | 40.736569 | -73.982152 | 40.744322 | 1 |
| 2011-08-12T04:20:00.000+0000 | 24.9 | 2011-08-12T04:20:00.000+0000 | -74.006662 | 40.73121 | -73.92594 | 40.825588 | 1 |
| 2013-02-06T22:16:00.000+0000 | 7.0 | 2013-02-06T22:16:00.000+0000 | -73.988425 | 40.764342 | -74.001642 | 40.745752 | 2 |
| 2014-06-11T22:24:21.000+0000 | 8.5 | 2014-06-11T22:24:21.000+0000 | -73.994128 | 40.735087 | -73.986393 | 40.751461 | 1 |
| 2010-08-19T16:33:00.000+0000 | 5.7 | 2010-08-19T16:33:00.000+0000 | -73.97383 | 40.763717 | -73.98942 | 40.771522 | 1 |
| 2013-03-10T15:44:00.000+0000 | 5.0 | 2013-03-10T15:44:00.000+0000 | -74.01336 | 40.702272 | -74.01699 | 40.709245 | 1 |
| 2013-06-14T08:27:43.000+0000 | 8.5 | 2013-06-14T08:27:43.000+0000 | -73.95371 | 40.790813 | -73.957015 | 40.777676 | 1 |
| 2013-07-08T21:24:00.000+0000 | 17.0 | 2013-07-08T21:24:00.000+0000 | -74.009728 | 40.705167 | -73.970897 | 40.749307 | 1 |
| 2014-03-21T11:00:29.000+0000 | 8.0 | 2014-03-21T11:00:29.000+0000 | -73.950688 | 40.828531 | -73.964101 | 40.80814 | 1 |
| 2014-10-02T13:39:56.000+0000 | 12.0 | 2014-10-02T13:39:56.000+0000 | -73.995387 | 40.749482 | -73.975789 | 40.748741 | 1 |
| 2011-08-31T08:21:47.000+0000 | 12.5 | 2011-08-31T08:21:47.000+0000 | -73.917399 | 40.746485 | -73.973756 | 40.763836 | 1 |
| 2014-05-19T06:26:00.000+0000 | 7.5 | 2014-05-19T06:26:00.000+0000 | -73.990815 | 40.730495 | -73.978337 | 40.751085 | 1 |
| 2012-04-05T05:50:00.000+0000 | 6.9 | 2012-04-05T05:50:00.000+0000 | -74.007443 | 40.732547 | -73.991112 | 40.742312 | 5 |
| 2015-03-04T14:55:40.000+0000 | 5.0 | 2015-03-04T14:55:40.000+0000 | -73.9887466430664 | 40.74495315551758 | -73.99568176269531 | 40.74422073364258 | 2 |
| 2010-04-27T21:40:07.000+0000 | 10.5 | 2010-04-27T21:40:07.000+0000 | -74.001135 | 40.730979 | -73.984424 | 40.76463 | 1 |
| 2011-02-22T11:09:16.000+0000 | 7.7 | 2011-02-22T11:09:16.000+0000 | -73.968881 | 40.764533 | -73.985311 | 40.748956 | 1 |
| 2015-04-03T16:21:30.000+0000 | 11.0 | 2015-04-03T16:21:30.000+0000 | -73.9810562133789 | 40.77426528930664 | -73.95904541015625 | 40.78067398071289 | 2 |
| 2009-01-09T15:01:20.000+0000 | 5.7 | 2009-01-09T15:01:20.000+0000 | -73.992826 | 40.751271 | -73.982786 | 40.742432 | 1 |
| 2013-01-09T14:42:00.000+0000 | 9.0 | 2013-01-09T14:42:00.000+0000 | -73.946852 | 40.775802 | -73.96434 | 40.760703 | 1 |
| 2013-07-06T17:18:00.000+0000 | 13.5 | 2013-07-06T17:18:00.000+0000 | -73.950655 | 40.783282 | -73.984365 | 40.769802 | 1 |
| 2013-10-08T17:29:00.000+0000 | 7.5 | 2013-10-08T17:29:00.000+0000 | -73.976512 | 40.765277 | -73.977672 | 40.778052 | 1 |
| 2014-12-07T12:26:00.000+0000 | 9.0 | 2014-12-07T12:26:00.000+0000 | -73.984977 | 40.752122 | -74.000925 | 40.757982 | 1 |
| 2015-05-17T08:02:59.000+0000 | 14.0 | 2015-05-17T08:02:59.000+0000 | -73.97920989990233 | 40.723682403564446 | -74.01746368408203 | 40.71139526367188 | 1 |
| 2011-06-09T00:53:00.000+0000 | 5.7 | 2011-06-09T00:53:00.000+0000 | -73.983052 | 40.722588 | -73.988022 | 40.733738 | 3 |
| 2014-11-12T12:40:29.000+0000 | 10.0 | 2014-11-12T12:40:29.000+0000 | -74.002581 | 40.739572 | -73.99458 | 40.760682 | 1 |
| 2010-06-04T14:49:00.000+0000 | 5.7 | 2010-06-04T14:49:00.000+0000 | -73.993452 | 40.761447 | -73.979662 | 40.759618 | 5 |
| 2010-11-08T20:42:00.000+0000 | 9.7 | 2010-11-08T20:42:00.000+0000 | -73.970705 | 40.761643 | -73.992833 | 40.727647 | 2 |
| 2011-03-09T07:24:34.000+0000 | 14.1 | 2011-03-09T07:24:34.000+0000 | -73.974492 | 40.751369 | -74.010585 | 40.703364 | 1 |
| 2011-08-04T10:38:00.000+0000 | 7.7 | 2011-08-04T10:38:00.000+0000 | -73.991607 | 40.76318 | -73.982718 | 40.76239 | 2 |
| 2009-03-25T00:08:52.000+0000 | 52.0 | 2009-03-25T00:08:52.000+0000 | -74.035839 | 40.74732 | -74.035839 | 40.74732 | 1 |
| 2010-03-22T10:01:00.000+0000 | 11.3 | 2010-03-22T10:01:00.000+0000 | -74.00767 | 40.732177 | -73.974663 | 40.758932 | 1 |
| 2012-03-25T09:22:45.000+0000 | 8.5 | 2012-03-25T09:22:45.000+0000 | -73.986681 | 40.725659 | -73.977068 | 40.754504 | 1 |
| 2012-06-05T09:16:00.000+0000 | 12.9 | 2012-06-05T09:16:00.000+0000 | -73.965315 | 40.790852 | -73.978195 | 40.766375 | 6 |
| 2012-11-06T11:33:14.000+0000 | 9.5 | 2012-11-06T11:33:14.000+0000 | -73.972195 | 40.765883 | -73.967942 | 40.761951 | 1 |
| 2014-05-22T18:30:00.000+0000 | 9.0 | 2014-05-22T18:30:00.000+0000 | -73.982272 | 40.748357 | -73.969325 | 40.763877 | 1 |
| 2014-10-17T08:28:00.000+0000 | 10.0 | 2014-10-17T08:28:00.000+0000 | -73.991797 | 40.735262 | -73.975915 | 40.748697 | 6 |
| 2012-12-06T18:05:00.000+0000 | 35.0 | 2012-12-06T18:05:00.000+0000 | -73.95331 | 40.787772 | -73.944352 | 40.719772 | 2 |
| 2012-12-06T18:05:00.000+0000 | 9.0 | 2012-12-06T18:05:00.000+0000 | -73.96083 | 40.77308 | -73.978372 | 40.774907 | 1 |
| 2014-07-20T12:48:35.000+0000 | 17.0 | 2014-07-20T12:48:35.000+0000 | -73.97339 | 40.743883 | -73.954021 | 40.766063 | 1 |
| 2009-01-25T18:41:00.000+0000 | 6.1 | 2009-01-25T18:41:00.000+0000 | -74.000122 | 40.74308 | -74.00615 | 40.734233 | 5 |
| 2010-03-27T02:26:39.000+0000 | 14.5 | 2010-03-27T02:26:39.000+0000 | -73.961598 | 40.716487 | -73.960417 | 40.674963 | 2 |
| 2011-01-05T17:39:00.000+0000 | 3.7 | 2011-01-05T17:39:00.000+0000 | -73.966957 | 40.761268 | -73.967912 | 40.765535 | 1 |
| 2012-05-11T15:03:53.000+0000 | 32.5 | 2012-05-11T15:03:53.000+0000 | -73.872862 | 40.774105 | -73.970593 | 40.764393 | 2 |
| 2010-01-03T10:20:12.000+0000 | 5.3 | 2010-01-03T10:20:12.000+0000 | -73.995083 | 40.739527 | -73.999599 | 40.726264 | 3 |
| 2012-11-08T21:00:00.000+0000 | 11.5 | 2012-11-08T21:00:00.000+0000 | -73.972018 | 40.750142 | -74.006008 | 40.73622 | 5 |
| 2013-11-23T23:34:03.000+0000 | 4.0 | 2013-11-23T23:34:03.000+0000 | -73.993701 | 40.741569 | -73.987999 | 40.748834 | 1 |
| 2010-06-17T16:12:58.000+0000 | 10.5 | 2010-06-17T16:12:58.000+0000 | -73.966473 | 40.7575 | -73.993336 | 40.745051 | 1 |
| 2012-08-19T19:56:34.000+0000 | 17.7 | 2012-08-19T19:56:34.000+0000 | -73.87082 | 40.773748 | -73.808317 | 40.7003 | 1 |
| 2013-01-17T17:22:00.000+0000 | 8.0 | 2013-01-17T17:22:00.000+0000 | 0.0 | 0.0 | 0.0 | 0.0 | 2 |
| 2013-05-10T16:39:08.000+0000 | 5.0 | 2013-05-10T16:39:08.000+0000 | -73.971696 | 40.763378 | -73.962035 | 40.776598 | 1 |
| 2013-09-17T04:22:00.000+0000 | 19.0 | 2013-09-17T04:22:00.000+0000 | -73.98721 | 40.729325 | -73.931985 | 40.697207 | 1 |
| 2014-01-06T21:21:00.000+0000 | 8.0 | 2014-01-06T21:21:00.000+0000 | -73.988492 | 40.717977 | -73.97818 | 40.737407 | 1 |
| 2010-09-30T08:38:00.000+0000 | 7.3 | 2010-09-30T08:38:00.000+0000 | -73.986588 | 40.72165 | -74.008005 | 40.717167 | 2 |
| 2012-10-06T15:47:00.000+0000 | 6.5 | 2012-10-06T15:47:00.000+0000 | -73.98213 | 40.774807 | -73.973583 | 40.789645 | 5 |
| 2013-02-11T00:13:00.000+0000 | 8.0 | 2013-02-11T00:13:00.000+0000 | -74.002843 | 40.733692 | -73.987882 | 40.72859 | 1 |
| 2014-09-12T23:10:00.000+0000 | 16.5 | 2014-09-12T23:10:00.000+0000 | -73.983837 | 40.676052 | -74.002522 | 40.723145 | 1 |
| 2009-09-22T21:14:00.000+0000 | 49.57 | 2009-09-22T21:14:00.000+0000 | -73.977023 | 40.7526 | -73.79031 | 40.643783 | 2 |
| 2012-02-03T13:46:35.000+0000 | 10.5 | 2012-02-03T13:46:35.000+0000 | -73.988006 | 40.737723 | -73.965699 | 40.766095 | 1 |
| 2012-02-12T01:26:00.000+0000 | 22.5 | 2012-02-12T01:26:00.000+0000 | -73.9882 | 40.75909 | -73.923683 | 40.86861 | 5 |
| 2012-12-21T06:47:00.000+0000 | 11.5 | 2012-12-21T06:47:00.000+0000 | -73.947472 | 40.771227 | -73.981832 | 40.760272 | 1 |
| 2014-11-01T16:51:09.000+0000 | 12.5 | 2014-11-01T16:51:09.000+0000 | -73.984723 | 40.748023 | -73.977245 | 40.757891 | 2 |
| 2013-01-26T18:36:00.000+0000 | 5.5 | 2013-01-26T18:36:00.000+0000 | -73.950305 | 40.785607 | -73.943587 | 40.789532 | 1 |
| 2013-05-20T11:03:50.000+0000 | 6.5 | 2013-05-20T11:03:50.000+0000 | -73.980735 | 40.747911 | -73.97053 | 40.761998 | 1 |
| 2015-05-31T07:33:18.000+0000 | 16.5 | 2015-05-31T07:33:18.000+0000 | -73.99698638916014 | 40.75542831420898 | -73.95319366455078 | 40.80210113525391 | 3 |
| 2015-02-15T22:41:32.000+0000 | 9.0 | 2015-02-15T22:41:32.000+0000 | -74.00344848632812 | 40.73310089111328 | -74.00800323486328 | 40.70721435546875 | 1 |
| 2009-06-25T10:29:00.000+0000 | 8.9 | 2009-06-25T10:29:00.000+0000 | -73.9578 | 40.768003 | -73.981712 | 40.763392 | 1 |
| 2009-07-23T17:05:10.000+0000 | 10.9 | 2009-07-23T17:05:10.000+0000 | -73.983735 | 40.746697 | -73.954411 | 40.772219 | 1 |
| 2011-03-19T15:00:27.000+0000 | 8.9 | 2011-03-19T15:00:27.000+0000 | -73.98103 | 40.729782 | -73.993011 | 40.752803 | 1 |
| 2011-05-06T11:37:14.000+0000 | 8.5 | 2011-05-06T11:37:14.000+0000 | -73.963115 | 40.774034 | -73.975251 | 40.760823 | 1 |
| 2013-02-08T09:50:04.000+0000 | 17.0 | 2013-02-08T09:50:04.000+0000 | -73.962458 | 40.759027 | -73.986199 | 40.753397 | 1 |
| 2010-08-24T01:39:26.000+0000 | 12.5 | 2010-08-24T01:39:26.000+0000 | -74.003848 | 40.720855 | -73.98098 | 40.668304 | 1 |
| 2014-05-13T22:19:00.000+0000 | 52.5 | 2014-05-13T22:19:00.000+0000 | -73.982265 | 40.762062 | -73.76855 | 40.675135 | 1 |
| 2014-10-25T21:24:00.000+0000 | 16.0 | 2014-10-25T21:24:00.000+0000 | -74.005677 | 40.745547 | -73.962663 | 40.794295 | 1 |
| 2015-04-19T22:21:12.000+0000 | 8.0 | 2015-04-19T22:21:12.000+0000 | -73.98548889160156 | 40.74728012084961 | -74.00767517089844 | 40.740768432617195 | 1 |
| 2010-05-17T07:44:00.000+0000 | 17.3 | 2010-05-17T07:44:00.000+0000 | -73.950972 | 40.785633 | -74.01024 | 40.720302 | 1 |
| 2011-10-26T03:37:00.000+0000 | 5.7 | 2011-10-26T03:37:00.000+0000 | -74.00844 | 40.711253 | -74.001313 | 40.731078 | 1 |
| 2015-04-18T09:30:31.000+0000 | 5.5 | 2015-04-18T09:30:31.000+0000 | -73.98091125488281 | 40.7420654296875 | -73.97698974609375 | 40.75165557861328 | 1 |
| 2009-02-27T13:31:21.000+0000 | 16.5 | 2009-02-27T13:31:21.000+0000 | -73.974938 | 40.762091 | -74.003309 | 40.706195 | 2 |
| 2009-07-16T20:33:00.000+0000 | 12.9 | 2009-07-16T20:33:00.000+0000 | -73.980755 | 40.680558 | -73.98911 | 40.726788 | 2 |
| 2011-05-16T13:10:38.000+0000 | 10.1 | 2011-05-16T13:10:38.000+0000 | -73.991245 | 40.739058 | -73.992972 | 40.76768 | 1 |
| 2013-08-09T21:19:00.000+0000 | 9.5 | 2013-08-09T21:19:00.000+0000 | -73.992583 | 40.730417 | -74.005352 | 40.740247 | 1 |
| 2010-03-14T15:40:00.000+0000 | 4.5 | 2010-03-14T15:40:00.000+0000 | -73.979872 | 40.749027 | -73.976553 | 40.757498 | 5 |
| 2011-04-27T13:19:48.000+0000 | 6.5 | 2011-04-27T13:19:48.000+0000 | -73.971541 | 40.764009 | -73.975937 | 40.755971 | 1 |
| 2015-01-30T00:16:06.000+0000 | 21.5 | 2015-01-30T00:16:06.000+0000 | -74.0010986328125 | 40.72149658203125 | -73.95943450927734 | 40.6530647277832 | 1 |
| 2014-11-04T12:11:19.000+0000 | 8.0 | 2014-11-04T12:11:19.000+0000 | -73.975189 | 40.759095 | -73.98051 | 40.76761 | 1 |
| 2009-12-27T21:07:39.000+0000 | 4.9 | 2009-12-27T21:07:39.000+0000 | -74.003018 | 40.73978 | -73.991533 | 40.733091 | 1 |
| 2010-07-04T13:07:47.000+0000 | 5.7 | 2010-07-04T13:07:47.000+0000 | -73.991037 | 40.750049 | -73.980438 | 40.75193 | 2 |
| 2011-06-12T13:33:00.000+0000 | 15.3 | 2011-06-12T13:33:00.000+0000 | -73.949477 | 40.768018 | -74.003118 | 40.733022 | 5 |
| 2012-08-28T12:29:40.000+0000 | 14.9 | 2012-08-28T12:29:40.000+0000 | -73.992214 | 40.758864 | -73.9938 | 40.722718 | 1 |
| 2012-11-11T18:23:00.000+0000 | 7.0 | 2012-11-11T18:23:00.000+0000 | -73.999998 | 40.727087 | -73.992448 | 40.735602 | 1 |
| 2013-03-24T18:05:42.000+0000 | 35.5 | 2013-03-24T18:05:42.000+0000 | -73.863891 | 40.770005 | -74.007246 | 40.705533 | 1 |
| 2014-08-13T08:26:00.000+0000 | 8.5 | 2014-08-13T08:26:00.000+0000 | -73.954598 | 40.78676 | -73.966013 | 40.768112 | 1 |
| 2009-01-16T21:10:00.000+0000 | 4.5 | 2009-01-16T21:10:00.000+0000 | -73.994143 | 40.751193 | -73.988897 | 40.759742 | 1 |
| 2011-01-21T18:43:46.000+0000 | 4.1 | 2011-01-21T18:43:46.000+0000 | -73.982279 | 40.768364 | -73.985968 | 40.762939 | 1 |
| 2011-02-26T20:27:36.000+0000 | 11.7 | 2011-02-26T20:27:36.000+0000 | -73.981496 | 40.781004 | -73.99592 | 40.738813 | 1 |
| 2013-06-22T02:35:01.000+0000 | 23.0 | 2013-06-22T02:35:01.000+0000 | -73.997728 | 40.746099 | -73.947656 | 40.829451 | 1 |
| 2009-06-06T23:56:00.000+0000 | 5.7 | 2009-06-06T23:56:00.000+0000 | -73.982357 | 40.762498 | -73.97321 | 40.755345 | 2 |
| 2009-01-24T09:51:00.000+0000 | 5.3 | 2009-01-24T09:51:00.000+0000 | -73.96707 | 40.769178 | -73.954895 | 40.77821 | 1 |
| 2015-02-27T07:50:56.000+0000 | 10.5 | 2015-02-27T07:50:56.000+0000 | -73.94402313232422 | 40.77595901489258 | -73.95504760742188 | 40.78507995605469 | 1 |
| 2009-03-25T14:48:49.000+0000 | 4.9 | 2009-03-25T14:48:49.000+0000 | -73.982095 | 40.774001 | -73.975373 | 40.787111 | 1 |
| 2010-09-10T18:45:00.000+0000 | 6.5 | 2010-09-10T18:45:00.000+0000 | -73.98353 | 40.766992 | -73.986255 | 40.779708 | 4 |
| 2011-08-31T13:47:02.000+0000 | 11.3 | 2011-08-31T13:47:02.000+0000 | -73.981154 | 40.729204 | -74.007407 | 40.74851 | 2 |
| 2013-04-12T04:39:51.000+0000 | 11.5 | 2013-04-12T04:39:51.000+0000 | -73.963511 | 40.761732 | -73.917488 | 40.739776 | 1 |
| 2009-05-29T09:46:11.000+0000 | 5.3 | 2009-05-29T09:46:11.000+0000 | -73.983415 | 40.761844 | -73.990414 | 40.756375 | 2 |
| 2010-07-15T19:09:01.000+0000 | 5.7 | 2010-07-15T19:09:01.000+0000 | -74.006055 | 40.733166 | -74.002895 | 40.74553 | 1 |
| 2009-09-07T18:52:00.000+0000 | 8.1 | 2009-09-07T18:52:00.000+0000 | -73.952198 | 40.788107 | -73.980767 | 40.774995 | 1 |
| 2010-06-09T06:20:32.000+0000 | 6.1 | 2010-06-09T06:20:32.000+0000 | -74.008083 | 40.719238 | -73.99832 | 40.737977 | 1 |
| 2012-04-15T17:02:44.000+0000 | 9.3 | 2012-04-15T17:02:44.000+0000 | -73.995636 | 40.746573 | -73.984437 | 40.767145 | 1 |
| 2013-02-06T14:52:00.000+0000 | 4.5 | 2013-02-06T14:52:00.000+0000 | -73.972072 | 40.755692 | -73.972082 | 40.755727 | 2 |
| 2011-12-13T05:56:00.000+0000 | 5.7 | 2011-12-13T05:56:00.000+0000 | -73.99049 | 40.755982 | -73.974202 | 40.75421 | 4 |
| 2014-07-27T08:22:00.000+0000 | 16.5 | 2014-07-27T08:22:00.000+0000 | -73.95485 | 40.76542 | -74.00751 | 40.73877 | 2 |
| 2013-06-06T15:23:56.000+0000 | 17.0 | 2013-06-06T15:23:56.000+0000 | -73.954462 | 40.764046 | -73.994593 | 40.729272 | 2 |
| 2014-07-12T15:22:00.000+0000 | 24.5 | 2014-07-12T15:22:00.000+0000 | -74.01278 | 40.707952 | -73.997932 | 40.760632 | 6 |
| 2010-05-25T20:14:00.000+0000 | 6.1 | 2010-05-25T20:14:00.000+0000 | -74.005278 | 40.735298 | -73.986698 | 40.729892 | 1 |
| 2012-09-08T00:49:20.000+0000 | 6.0 | 2012-09-08T00:49:20.000+0000 | -74.004935 | 40.729625 | -74.016156 | 40.71741 | 1 |
| 2014-01-08T21:55:58.000+0000 | 6.5 | 2014-01-08T21:55:58.000+0000 | -73.998488 | 40.726303 | -73.998488 | 40.726303 | 1 |
| 2010-09-05T17:08:00.000+0000 | 3.7 | 2010-09-05T17:08:00.000+0000 | 0.0 | 0.0 | 0.0 | 0.0 | 5 |
| 2012-08-30T18:57:00.000+0000 | 4.5 | 2012-08-30T18:57:00.000+0000 | -73.9265 | 40.765577 | -73.937897 | 40.76451 | 3 |
| 2013-05-02T07:41:00.000+0000 | 27.0 | 2013-05-02T07:41:00.000+0000 | -73.987285 | 40.718622 | -73.959295 | 40.778482 | 1 |
| 2014-02-05T00:28:00.000+0000 | 16.0 | 2014-02-05T00:28:00.000+0000 | -73.996652 | 40.744495 | -73.980253 | 40.737635 | 1 |
| 2010-01-12T17:11:00.000+0000 | 16.1 | 2010-01-12T17:11:00.000+0000 | -73.959222 | 40.763282 | -73.9633 | 40.716935 | 1 |
| 2010-11-07T17:14:23.000+0000 | 15.7 | 2010-11-07T17:14:23.000+0000 | -73.974895 | 40.751455 | -73.981754 | 40.783542 | 2 |
| 2012-04-22T00:35:00.000+0000 | 26.9 | 2012-04-22T00:35:00.000+0000 | -73.863072 | 40.768622 | -73.982145 | 40.736167 | 6 |
| 2013-01-05T21:36:00.000+0000 | 5.5 | 2013-01-05T21:36:00.000+0000 | -73.989692 | 40.735497 | -73.982012 | 40.739392 | 1 |
| 2013-10-05T09:12:21.000+0000 | 6.0 | 2013-10-05T09:12:21.000+0000 | -74.00031 | 40.747961 | -73.993636 | 40.757229 | 1 |
| 2009-11-16T23:53:00.000+0000 | 7.7 | 2009-11-16T23:53:00.000+0000 | -74.00145 | 40.717487 | -74.017455 | 40.709785 | 1 |
| 2011-04-05T11:29:00.000+0000 | 12.9 | 2011-04-05T11:29:00.000+0000 | -73.985185 | 40.72777 | -73.980605 | 40.759143 | 1 |
| 2012-04-25T20:39:00.000+0000 | 11.3 | 2012-04-25T20:39:00.000+0000 | -73.993973 | 40.746577 | -74.00506 | 40.709365 | 1 |
| 2011-01-10T16:07:00.000+0000 | 42.5 | 2011-01-10T16:07:00.000+0000 | -73.795677 | 40.807722 | -73.978683 | 40.724365 | 2 |
| 2011-01-14T18:10:00.000+0000 | 5.7 | 2011-01-14T18:10:00.000+0000 | -73.98637 | 40.74738 | -73.975567 | 40.744572 | 2 |
| 2012-04-02T08:02:16.000+0000 | 5.3 | 2012-04-02T08:02:16.000+0000 | -73.948001 | 40.77854 | -73.958566 | 40.778483 | 2 |
| 2010-02-10T08:57:54.000+0000 | 10.5 | 2010-02-10T08:57:54.000+0000 | -73.954108 | 40.766901 | -73.984133 | 40.743475 | 1 |
| 2011-05-31T22:21:01.000+0000 | 7.3 | 2011-05-31T22:21:01.000+0000 | -73.994009 | 40.76144 | -73.972811 | 40.792574 | 1 |
| 2011-09-26T09:32:42.000+0000 | 4.5 | 2011-09-26T09:32:42.000+0000 | -73.995331 | 40.739986 | -73.987655 | 40.736707 | 1 |
| 2012-10-23T08:09:25.000+0000 | 12.5 | 2012-10-23T08:09:25.000+0000 | -73.982332 | 40.768633 | -73.983343 | 40.744372 | 1 |
| 2013-09-07T22:29:00.000+0000 | 16.5 | 2013-09-07T22:29:00.000+0000 | -73.9952 | 40.731697 | -73.94977 | 40.780347 | 1 |
| 2012-07-31T19:20:00.000+0000 | 4.9 | 2012-07-31T19:20:00.000+0000 | -74.002707 | 40.72664 | -73.991825 | 40.72722 | 2 |
| 2011-08-26T08:00:00.000+0000 | 4.1 | 2011-08-26T08:00:00.000+0000 | -73.990953 | 40.733067 | -73.996235 | 40.72557 | 1 |
| 2013-03-17T12:56:58.000+0000 | 15.5 | 2013-03-17T12:56:58.000+0000 | -73.985132 | 40.76853 | -74.002285 | 40.730008 | 1 |
| 2015-05-25T15:11:09.000+0000 | 11.0 | 2015-05-25T15:11:09.000+0000 | -73.97221374511719 | 40.76557159423828 | -73.97958374023438 | 40.73646926879882 | 1 |
| 2009-04-08T19:11:10.000+0000 | 4.9 | 2009-04-08T19:11:10.000+0000 | -73.998287 | 40.72749 | -73.989854 | 40.735239 | 2 |
| 2009-06-06T01:57:52.000+0000 | 11.3 | 2009-06-06T01:57:52.000+0000 | -73.980196 | 40.726966 | -73.956413 | 40.77547 | 1 |
| 2011-02-27T14:45:00.000+0000 | 7.3 | 2011-02-27T14:45:00.000+0000 | -73.983758 | 40.74643 | -73.963557 | 40.774088 | 1 |
| 2012-01-13T11:28:00.000+0000 | 14.9 | 2012-01-13T11:28:00.000+0000 | -73.955268 | 40.782767 | -73.932382 | 40.794812 | 6 |
| 2012-03-16T07:58:00.000+0000 | 30.9 | 2012-03-16T07:58:00.000+0000 | -73.981942 | 40.763977 | -73.870455 | 40.773607 | 5 |
| 2012-06-18T20:57:27.000+0000 | 6.1 | 2012-06-18T20:57:27.000+0000 | -73.98972 | 40.75238 | -74.007553 | 40.743197 | 1 |
| 2010-02-23T09:49:00.000+0000 | 3.3 | 2010-02-23T09:49:00.000+0000 | -73.995802 | 40.749905 | -73.994543 | 40.750907 | 1 |
| 2012-01-06T07:05:08.000+0000 | 4.1 | 2012-01-06T07:05:08.000+0000 | -73.991863 | 40.754275 | -73.983796 | 40.753213 | 1 |
| 2014-07-21T14:03:00.000+0000 | 12.0 | 2014-07-21T14:03:00.000+0000 | -73.973857 | 40.764185 | -73.994435 | 40.750242 | 3 |
| 2014-08-05T11:44:33.000+0000 | 9.0 | 2014-08-05T11:44:33.000+0000 | -73.991485 | 40.754599 | -74.00497 | 40.751693 | 1 |
| 2012-03-29T03:51:00.000+0000 | 2.5 | 2012-03-29T03:51:00.000+0000 | -73.989142 | 40.720105 | -73.988777 | 40.720662 | 1 |
| 2012-06-30T13:43:00.000+0000 | 8.9 | 2012-06-30T13:43:00.000+0000 | -73.98948 | 40.743287 | -73.965692 | 40.754512 | 1 |
| 2014-01-31T04:49:53.000+0000 | 10.5 | 2014-01-31T04:49:53.000+0000 | -73.978991 | 40.72375 | -73.963046 | 40.711855 | 1 |
| 2010-11-16T19:40:00.000+0000 | 5.7 | 2010-11-16T19:40:00.000+0000 | -74.000552 | 40.727492 | -74.005037 | 40.719123 | 1 |
| 2012-12-15T19:11:53.000+0000 | 7.0 | 2012-12-15T19:11:53.000+0000 | -74.002462 | 40.718762 | -74.007071 | 40.705536 | 2 |
| 2014-07-20T23:51:54.000+0000 | 12.0 | 2014-07-20T23:51:54.000+0000 | -73.984997 | 40.768466 | -73.944564 | 40.800466 | 1 |
| 2010-05-24T14:24:00.000+0000 | 49.57 | 2010-05-24T14:24:00.000+0000 | -73.982483 | 40.75674 | -73.789985 | 40.64691 | 1 |
| 2011-07-24T01:14:35.000+0000 | 8.5 | 2011-07-24T01:14:35.000+0000 | 0.0 | 0.0 | 0.0 | 0.0 | 2 |
| 2012-08-18T18:33:00.000+0000 | 4.5 | 2012-08-18T18:33:00.000+0000 | -73.947035 | 40.776027 | -73.955498 | 40.764307 | 1 |
| 2009-08-08T21:32:00.000+0000 | 7.3 | 2009-08-08T21:32:00.000+0000 | -73.977897 | 40.762802 | -73.99153 | 40.750252 | 5 |
| 2010-01-08T00:28:00.000+0000 | 5.3 | 2010-01-08T00:28:00.000+0000 | -73.986402 | 40.754723 | -73.998898 | 40.739248 | 1 |
| 2010-09-19T19:28:00.000+0000 | 6.9 | 2010-09-19T19:28:00.000+0000 | -73.967425 | 40.755712 | -73.983035 | 40.734913 | 5 |
| 2012-05-16T18:14:00.000+0000 | 9.3 | 2012-05-16T18:14:00.000+0000 | -73.971088 | 40.792648 | -73.968405 | 40.769673 | 1 |
| 2009-02-13T16:54:52.000+0000 | 6.7 | 2009-02-13T16:54:52.000+0000 | -73.959669 | 40.779718 | -73.976259 | 40.788413 | 1 |
| 2009-06-20T19:28:37.000+0000 | 7.3 | 2009-06-20T19:28:37.000+0000 | -73.979345 | 40.77663 | -73.973842 | 40.757074 | 1 |
| 2013-09-03T08:08:00.000+0000 | 9.0 | 2013-09-03T08:08:00.000+0000 | -73.98088 | 40.779967 | -73.953747 | 40.78777 | 1 |
| 2013-01-20T14:33:27.000+0000 | 13.0 | 2013-01-20T14:33:27.000+0000 | -74.008125 | 40.738935 | -73.980522 | 40.759953 | 2 |
| 2013-07-31T06:51:13.000+0000 | 19.0 | 2013-07-31T06:51:13.000+0000 | -73.988834 | 40.76428 | -73.941405 | 40.838664 | 1 |
| 2013-09-09T22:12:59.000+0000 | 5.5 | 2013-09-09T22:12:59.000+0000 | -73.976474 | 40.765048 | -73.964665 | 40.762986 | 1 |
| 2009-01-23T07:28:00.000+0000 | 8.1 | 2009-01-23T07:28:00.000+0000 | -73.996068 | 40.732605 | -73.980675 | 40.761862 | 1 |
| 2011-02-18T13:19:49.000+0000 | 9.3 | 2011-02-18T13:19:49.000+0000 | -73.973211 | 40.760752 | -73.974265 | 40.788281 | 1 |
| 2013-05-11T19:51:00.000+0000 | 18.0 | 2013-05-11T19:51:00.000+0000 | -73.997845 | 40.721235 | -73.988257 | 40.764125 | 1 |
| 2014-09-13T12:17:00.000+0000 | 12.0 | 2014-09-13T12:17:00.000+0000 | -73.984227 | 40.766897 | -73.96239 | 40.776037 | 1 |
| 2009-04-21T22:59:27.000+0000 | 7.3 | 2009-04-21T22:59:27.000+0000 | -73.968534 | 40.752603 | -73.992625 | 40.742916 | 1 |
| 2009-09-26T15:17:20.000+0000 | 4.9 | 2009-09-26T15:17:20.000+0000 | -73.95554 | 40.781958 | -73.962196 | 40.772095 | 2 |
| 2010-05-28T21:33:07.000+0000 | 16.1 | 2010-05-28T21:33:07.000+0000 | -73.789506 | 40.64704 | -73.815622 | 40.680364 | 1 |
| 2011-05-02T08:20:11.000+0000 | 12.9 | 2011-05-02T08:20:11.000+0000 | -73.978602 | 40.76412 | -74.008858 | 40.715637 | 2 |
| 2015-02-14T19:00:23.000+0000 | 4.0 | 2015-02-14T19:00:23.000+0000 | -73.96197509765625 | 40.7761116027832 | -73.95484924316406 | 40.77407455444336 | 1 |
| 2011-05-02T12:44:59.000+0000 | 15.3 | 2011-05-02T12:44:59.000+0000 | -74.006636 | 40.751407 | -73.954979 | 40.765281 | 1 |
| 2012-06-24T17:33:00.000+0000 | 11.7 | 2012-06-24T17:33:00.000+0000 | -73.954497 | 40.769857 | -73.984315 | 40.746007 | 1 |
| 2010-05-22T23:29:57.000+0000 | 25.3 | 2010-05-22T23:29:57.000+0000 | -74.001343 | 40.74132 | -73.928619 | 40.864267 | 1 |
| 2010-06-30T02:22:05.000+0000 | 8.9 | 2010-06-30T02:22:05.000+0000 | -73.993112 | 40.719911 | -73.956729 | 40.720723 | 1 |
| 2013-04-26T02:06:00.000+0000 | 6.0 | 2013-04-26T02:06:00.000+0000 | -73.978778 | 40.753502 | -73.973247 | 40.748147 | 1 |
| 2013-05-02T03:57:12.000+0000 | 6.0 | 2013-05-02T03:57:12.000+0000 | -73.99578 | 40.716218 | -74.009132 | 40.72078 | 1 |
| 2011-01-23T11:44:28.000+0000 | 6.5 | 2011-01-23T11:44:28.000+0000 | -74.003665 | 40.736906 | -73.997843 | 40.724187 | 1 |
| 2012-10-14T21:06:27.000+0000 | 7.5 | 2012-10-14T21:06:27.000+0000 | -73.97733 | 40.74948 | -73.987669 | 40.732709 | 1 |
| 2015-04-30T14:07:57.000+0000 | 16.5 | 2015-04-30T14:07:57.000+0000 | -74.00399017333984 | 40.74797821044922 | -73.98319244384764 | 40.75632858276367 | 1 |
| 2010-07-12T09:44:33.000+0000 | 4.9 | 2010-07-12T09:44:33.000+0000 | -73.983249 | 40.734655 | -73.991278 | 40.738918 | 1 |
| 2012-01-08T19:03:15.000+0000 | 9.7 | 2012-01-08T19:03:15.000+0000 | -73.962981 | 40.766443 | -73.98893 | 40.731434 | 1 |
| 2012-04-24T13:00:36.000+0000 | 7.7 | 2012-04-24T13:00:36.000+0000 | -73.97935 | 40.784608 | -73.963933 | 40.808145 | 1 |
| 2014-05-09T09:42:16.000+0000 | 19.0 | 2014-05-09T09:42:16.000+0000 | -73.968675 | 40.799103 | -73.935898 | 40.849863 | 2 |
| 2009-07-31T13:53:52.000+0000 | 16.9 | 2009-07-31T13:53:52.000+0000 | -73.990057 | 40.756307 | -73.949604 | 40.834464 | 1 |
| 2012-11-18T12:17:00.000+0000 | 10.5 | 2012-11-18T12:17:00.000+0000 | -74.002198 | 40.739608 | -73.987342 | 40.720295 | 2 |
| 2011-06-15T18:07:00.000+0000 | 8.9 | 2011-06-15T18:07:00.000+0000 | -73.99633 | 40.753225 | -73.978895 | 40.766963 | 3 |
| 2012-08-25T01:53:42.000+0000 | 7.5 | 2012-08-25T01:53:42.000+0000 | -73.995892 | 40.746454 | -73.995892 | 40.746454 | 1 |
| 2012-09-06T13:41:00.000+0000 | 5.5 | 2012-09-06T13:41:00.000+0000 | -74.005583 | 40.740728 | -74.003423 | 40.748705 | 1 |
| 2009-05-13T18:17:00.000+0000 | 10.9 | 2009-05-13T18:17:00.000+0000 | -73.964958 | 40.775261 | -73.949661 | 40.809689 | 1 |
| 2009-10-30T18:13:00.000+0000 | 8.1 | 2009-10-30T18:13:00.000+0000 | 0.0 | 0.0 | 0.0 | 0.0 | 4 |
| 2010-01-17T22:07:00.000+0000 | 5.7 | 2010-01-17T22:07:00.000+0000 | -73.967598 | 40.756242 | -73.953277 | 40.76833 | 1 |
| 2009-12-06T11:58:29.000+0000 | 18.1 | 2009-12-06T11:58:29.000+0000 | -74.008134 | 40.748631 | -73.952349 | 40.780512 | 2 |
| 2010-06-30T06:15:00.000+0000 | 10.9 | 2010-06-30T06:15:00.000+0000 | -73.95394 | 40.781298 | -73.994423 | 40.75014 | 5 |
| 2011-04-04T18:56:00.000+0000 | 8.9 | 2011-04-04T18:56:00.000+0000 | -73.939093 | 40.805102 | -73.956073 | 40.771995 | 5 |
| 2014-03-03T23:30:00.000+0000 | 13.5 | 2014-03-03T23:30:00.000+0000 | -73.981627 | 40.78042 | -74.008465 | 40.734012 | 2 |
| 2014-05-19T20:59:26.000+0000 | 5.0 | 2014-05-19T20:59:26.000+0000 | -74.00269 | 40.739438 | -73.994579 | 40.75057 | 2 |
| 2011-12-07T19:40:21.000+0000 | 5.3 | 2011-12-07T19:40:21.000+0000 | -73.958749 | 40.781019 | -73.945876 | 40.778165 | 1 |
| 2012-06-17T02:05:53.000+0000 | 7.7 | 2012-06-17T02:05:53.000+0000 | -73.98779 | 40.721226 | -73.992425 | 40.735723 | 1 |
| 2013-01-01T14:26:00.000+0000 | 9.0 | 2013-01-01T14:26:00.000+0000 | -73.969465 | 40.79798 | -73.982315 | 40.776767 | 1 |
| 2011-10-08T00:24:00.000+0000 | 16.1 | 2011-10-08T00:24:00.000+0000 | -73.988568 | 40.732097 | -73.957498 | 40.742657 | 1 |
| 2012-07-30T16:19:08.000+0000 | 4.9 | 2012-07-30T16:19:08.000+0000 | -73.966597 | 40.794345 | -73.965682 | 40.803808 | 2 |
| 2012-09-09T10:24:15.000+0000 | 5.5 | 2012-09-09T10:24:15.000+0000 | -73.999432 | 40.749066 | -73.995077 | 40.738264 | 1 |
| 2013-06-14T17:37:00.000+0000 | 57.33 | 2013-06-14T17:37:00.000+0000 | -73.781127 | 40.645007 | -73.981802 | 40.762515 | 1 |
| 2014-02-28T22:45:07.000+0000 | 8.5 | 2014-02-28T22:45:07.000+0000 | -73.956606 | 40.771111 | -73.977111 | 40.776811 | 3 |
| 2014-06-10T14:18:29.000+0000 | 9.5 | 2014-06-10T14:18:29.000+0000 | -73.981932 | 40.777668 | -73.960058 | 40.809688 | 1 |
| 2015-03-29T13:31:25.000+0000 | 7.5 | 2015-03-29T13:31:25.000+0000 | -73.9531021118164 | 40.788700103759766 | -73.95677947998048 | 40.80590438842773 | 1 |
| 2009-12-14T12:33:00.000+0000 | 6.9 | 2009-12-14T12:33:00.000+0000 | -73.982432 | 40.745747 | -73.982432 | 40.745747 | 1 |
| 2013-09-21T02:54:00.000+0000 | 7.5 | 2013-09-21T02:54:00.000+0000 | -73.991995 | 40.74499 | -73.986237 | 40.729637 | 2 |
| 2009-08-31T10:25:00.000+0000 | 8.1 | 2009-08-31T10:25:00.000+0000 | -73.988988 | 40.777013 | -73.997445 | 40.760155 | 1 |
| 2011-01-18T23:48:00.000+0000 | 6.1 | 2011-01-18T23:48:00.000+0000 | -74.006642 | 40.738927 | -74.010828 | 40.717907 | 3 |
| 2012-06-26T13:08:14.000+0000 | 5.7 | 2012-06-26T13:08:14.000+0000 | -73.966612 | 40.759278 | -73.975773 | 40.755462 | 1 |
| 2010-01-21T08:39:00.000+0000 | 14.1 | 2010-01-21T08:39:00.000+0000 | -73.987365 | 40.738572 | -73.977218 | 40.775352 | 1 |
| 2011-07-21T15:43:00.000+0000 | 5.7 | 2011-07-21T15:43:00.000+0000 | -73.989807 | 40.74123 | -73.993917 | 40.726492 | 1 |
| 2013-11-06T11:26:54.000+0000 | 7.0 | 2013-11-06T11:26:54.000+0000 | -73.95906 | 40.781061 | -73.96206 | 40.768604 | 1 |
| 2014-02-09T02:17:00.000+0000 | 12.0 | 2014-02-09T02:17:00.000+0000 | -73.985652 | 40.72212 | -73.970955 | 40.751952 | 1 |
| 2015-04-18T08:29:08.000+0000 | 11.5 | 2015-04-18T08:29:08.000+0000 | -73.95511627197266 | 40.76898956298828 | -73.98423767089844 | 40.74843978881836 | 1 |
| 2010-03-27T22:20:51.000+0000 | 12.1 | 2010-03-27T22:20:51.000+0000 | -73.870936 | 40.773703 | -73.914269 | 40.753681 | 1 |
| 2010-06-15T13:31:08.000+0000 | 26.67 | 2010-06-15T13:31:08.000+0000 | -73.958063 | 40.760414 | -73.861443 | 40.768181 | 1 |
| 2010-09-13T09:37:00.000+0000 | 4.5 | 2010-09-13T09:37:00.000+0000 | -73.98674 | 40.755362 | -73.995713 | 40.764137 | 1 |
| 2011-04-04T20:59:01.000+0000 | 10.1 | 2011-04-04T20:59:01.000+0000 | -73.984556 | 40.742882 | -73.959081 | 40.763551 | 1 |
| 2011-05-08T10:43:27.000+0000 | 7.7 | 2011-05-08T10:43:27.000+0000 | -73.981019 | 40.781874 | -73.981997 | 40.756597 | 1 |
| 2014-07-11T05:07:00.000+0000 | 25.0 | 2014-07-11T05:07:00.000+0000 | -73.95166 | 40.772657 | -74.010583 | 40.721405 | 2 |
| 2014-08-21T10:21:17.000+0000 | 19.0 | 2014-08-21T10:21:17.000+0000 | -73.97402 | 40.762828 | -73.940839 | 40.726467 | 1 |
| 2013-10-31T11:49:16.000+0000 | 14.0 | 2013-10-31T11:49:16.000+0000 | -73.988594 | 40.753364 | -73.989319 | 40.723218 | 1 |
| 2013-11-15T01:51:35.000+0000 | 5.0 | 2013-11-15T01:51:35.000+0000 | -73.987888 | 40.721048 | -73.983132 | 40.731187 | 1 |
| 2015-05-10T22:41:10.000+0000 | 43.5 | 2015-05-10T22:41:10.000+0000 | -73.98020935058595 | 40.78373336791992 | -74.01134490966798 | 40.64415740966797 | 1 |
| 2015-06-20T09:50:28.000+0000 | 8.0 | 2015-06-20T09:50:28.000+0000 | -74.01072692871094 | 40.71009063720703 | -73.99810028076173 | 40.722900390625 | 1 |
| 2009-03-13T17:43:18.000+0000 | 8.7 | 2009-03-13T17:43:18.000+0000 | -73.977984 | 40.754546 | -73.958947 | 40.779093 | 4 |
| 2011-01-27T21:30:00.000+0000 | 3.7 | 2011-01-27T21:30:00.000+0000 | -73.970892 | 40.755915 | -73.966747 | 40.760517 | 1 |
| 2011-11-24T01:58:25.000+0000 | 20.5 | 2011-11-24T01:58:25.000+0000 | -73.965723 | 40.758641 | -73.937824 | 40.855636 | 1 |
| 2015-06-02T23:16:15.000+0000 | 34.0 | 2015-06-02T23:16:15.000+0000 | -73.97489929199219 | 40.751094818115234 | -73.9085464477539 | 40.88187789916992 | 0 |
| 2015-03-19T12:38:17.000+0000 | 52.83 | 2015-03-19T12:38:17.000+0000 | -73.87305450439453 | 40.77408599853516 | -73.98272705078125 | 40.7714958190918 | 1 |
| 2009-07-16T22:38:00.000+0000 | 6.1 | 2009-07-16T22:38:00.000+0000 | -73.978945 | 40.76707 | -73.977897 | 40.783568 | 1 |
| 2013-06-22T13:48:00.000+0000 | 8.5 | 2013-06-22T13:48:00.000+0000 | -73.976877 | 40.759192 | -73.991685 | 40.74981 | 1 |
| 2014-03-10T19:50:51.000+0000 | 20.0 | 2014-03-10T19:50:51.000+0000 | -73.893177 | 40.790756 | -73.892578 | 40.788483 | 1 |
| 2010-05-28T08:18:34.000+0000 | 10.5 | 2010-05-28T08:18:34.000+0000 | -73.985881 | 40.7383 | -73.96499 | 40.775237 | 1 |
| 2012-03-10T22:53:25.000+0000 | 26.5 | 2012-03-10T22:53:25.000+0000 | -73.776747 | 40.645265 | -73.813803 | 40.709035 | 1 |
| 2015-06-01T21:41:06.000+0000 | 8.0 | 2015-06-01T21:41:06.000+0000 | -73.96178436279298 | 40.759578704833984 | -73.97894287109375 | 40.772605895996094 | 4 |
| 2009-01-26T00:44:42.000+0000 | 10.6 | 2009-01-26T00:44:42.000+0000 | -73.994279 | 40.690409 | -74.016739 | 40.709063 | 1 |
| 2010-09-21T07:06:31.000+0000 | 4.5 | 2010-09-21T07:06:31.000+0000 | -73.965372 | 40.759256 | -73.97487 | 40.752373 | 1 |
| 2011-03-09T22:21:25.000+0000 | 9.7 | 2011-03-09T22:21:25.000+0000 | -73.977829 | 40.788979 | -73.967935 | 40.760508 | 1 |
| 2011-12-05T08:38:34.000+0000 | 20.5 | 2011-12-05T08:38:34.000+0000 | -73.968619 | 40.766432 | -74.008559 | 40.704591 | 1 |
| 2012-01-06T10:57:10.000+0000 | 9.3 | 2012-01-06T10:57:10.000+0000 | -73.982229 | 40.731822 | -73.980239 | 40.760162 | 1 |
| 2014-05-25T21:09:00.000+0000 | 18.5 | 2014-05-25T21:09:00.000+0000 | -74.005385 | 40.707002 | -73.992793 | 40.750742 | 1 |
| 2014-04-27T21:56:45.000+0000 | 5.0 | 2014-04-27T21:56:45.000+0000 | -73.982751 | 40.762738 | -73.978354 | 40.764564 | 2 |
| 2009-08-03T08:19:45.000+0000 | 34.0 | 2009-08-03T08:19:45.000+0000 | -73.863506 | 40.769985 | -73.97582 | 40.765446 | 1 |
| 2012-11-08T20:07:35.000+0000 | 23.5 | 2012-11-08T20:07:35.000+0000 | -73.992028 | 40.75497 | -73.912663 | 40.780157 | 1 |
| 2009-12-11T15:57:17.000+0000 | 4.5 | 2009-12-11T15:57:17.000+0000 | -73.980909 | 40.774585 | -73.98136 | 40.779419 | 3 |
| 2013-12-07T13:25:00.000+0000 | 8.0 | 2013-12-07T13:25:00.000+0000 | -73.985217 | 40.742177 | -73.99998 | 40.726917 | 1 |
| 2010-02-27T20:13:00.000+0000 | 26.5 | 2010-02-27T20:13:00.000+0000 | -73.977765 | 40.766177 | -73.977982 | 40.766937 | 5 |
| 2014-12-24T11:23:00.000+0000 | 5.5 | 2014-12-24T11:23:00.000+0000 | -74.004822 | 40.741812 | -74.007312 | 40.733577 | 2 |
| 2009-03-23T20:24:00.000+0000 | 6.1 | 2009-03-23T20:24:00.000+0000 | -73.98795 | 40.757852 | -73.988227 | 40.749963 | 1 |
| 2010-03-23T17:43:00.000+0000 | 4.9 | 2010-03-23T17:43:00.000+0000 | -73.970442 | 40.764695 | -73.961907 | 40.765392 | 4 |
| 2010-01-26T14:55:00.000+0000 | 5.3 | 2010-01-26T14:55:00.000+0000 | -73.993085 | 40.752002 | -73.980337 | 40.76483 | 1 |
| 2011-07-05T14:23:00.000+0000 | 8.1 | 2011-07-05T14:23:00.000+0000 | -73.99097 | 40.742158 | -73.977728 | 40.72673 | 1 |
| 2013-04-01T00:04:15.000+0000 | 20.33 | 2013-04-01T00:04:15.000+0000 | -73.994718 | 40.750306 | -73.950511 | 40.728566 | 1 |
| 2013-06-28T20:24:00.000+0000 | 4.5 | 2013-06-28T20:24:00.000+0000 | -73.955282 | 40.768865 | -73.949683 | 40.776472 | 1 |
| 2014-05-12T12:11:28.000+0000 | 7.0 | 2014-05-12T12:11:28.000+0000 | -74.002792 | 40.760515 | -74.004415 | 40.741973 | 1 |
| 2009-07-11T12:20:03.000+0000 | 7.7 | 2009-07-11T12:20:03.000+0000 | -73.987145 | 40.722568 | -74.005402 | 40.739583 | 1 |
| 2009-10-16T10:32:00.000+0000 | 7.3 | 2009-10-16T10:32:00.000+0000 | -73.990575 | 40.746117 | -74.003227 | 40.751447 | 1 |
| 2010-06-09T14:53:47.000+0000 | 33.07 | 2010-06-09T14:53:47.000+0000 | -73.862764 | 40.769064 | -73.984033 | 40.752842 | 2 |
| 2011-05-04T13:44:00.000+0000 | 36.5 | 2011-05-04T13:44:00.000+0000 | -73.873068 | 40.774183 | -73.978847 | 40.762062 | 5 |
| 2014-01-01T05:22:00.000+0000 | 5.0 | 2014-01-01T05:22:00.000+0000 | -73.99436 | 40.72039 | -73.98577 | 40.72304 | 2 |
| 2014-06-25T17:43:16.000+0000 | 23.5 | 2014-06-25T17:43:16.000+0000 | -73.958585 | 40.775615 | -74.00048 | 40.737611 | 1 |
| 2012-05-09T15:26:00.000+0000 | 6.1 | 2012-05-09T15:26:00.000+0000 | -73.97985 | 40.786315 | -73.985068 | 40.774133 | 1 |
| 2013-01-12T18:10:00.000+0000 | 11.0 | 2013-01-12T18:10:00.000+0000 | -73.956597 | 40.777432 | -73.980035 | 40.763175 | 1 |
| 2014-09-05T15:23:00.000+0000 | 6.0 | 2014-09-05T15:23:00.000+0000 | -73.96826 | 40.76514 | -73.961115 | 40.774882 | 6 |
| 2009-09-20T11:32:00.000+0000 | 11.3 | 2009-09-20T11:32:00.000+0000 | -73.975868 | 40.790142 | -74.006695 | 40.751278 | 5 |
| 2009-11-15T19:58:00.000+0000 | 8.1 | 2009-11-15T19:58:00.000+0000 | -73.990397 | 40.75103 | -73.981137 | 40.764718 | 1 |
| 2010-03-28T22:32:44.000+0000 | 8.9 | 2010-03-28T22:32:44.000+0000 | -74.000763 | 40.729744 | -73.974662 | 40.749159 | 3 |
| 2011-02-19T22:25:00.000+0000 | 4.5 | 2011-02-19T22:25:00.000+0000 | -73.99784 | 40.68295 | -73.980198 | 40.676842 | 1 |
| 2013-01-31T19:38:05.000+0000 | 11.0 | 2013-01-31T19:38:05.000+0000 | -73.978836 | 40.764745 | -73.984774 | 40.745978 | 1 |
| 2013-06-18T10:27:05.000+0000 | 8.5 | 2013-06-18T10:27:05.000+0000 | -73.992108 | 40.764203 | -73.973 | 40.762695 | 1 |
| 2013-07-04T16:41:27.000+0000 | 8.5 | 2013-07-04T16:41:27.000+0000 | 0.0 | 0.0 | 0.0 | 0.0 | 1 |
| 2010-01-15T11:11:07.000+0000 | 8.1 | 2010-01-15T11:11:07.000+0000 | -73.978916 | 40.78712 | -73.957307 | 40.783588 | 1 |
| 2010-09-19T15:17:00.000+0000 | 6.9 | 2010-09-19T15:17:00.000+0000 | -73.996268 | 40.738123 | -73.98238 | 40.73617 | 1 |
| 2013-11-19T22:09:00.000+0000 | 6.0 | 2013-11-19T22:09:00.000+0000 | -73.971462 | 40.761332 | -73.980797 | 40.768002 | 1 |
| 2009-04-27T20:28:39.000+0000 | 5.3 | 2009-04-27T20:28:39.000+0000 | -73.988927 | 40.760223 | -73.991474 | 40.750591 | 1 |
| 2011-11-27T00:57:39.000+0000 | 6.1 | 2011-11-27T00:57:39.000+0000 | -73.980068 | 40.743103 | -73.991181 | 40.750228 | 1 |
| 2012-11-10T00:30:53.000+0000 | 9.5 | 2012-11-10T00:30:53.000+0000 | -73.995776 | 40.748921 | -73.968821 | 40.764391 | 2 |
| 2013-12-18T09:15:00.000+0000 | 11.5 | 2013-12-18T09:15:00.000+0000 | -73.97941 | 40.766107 | -74.003015 | 40.750522 | 1 |
| 2015-03-14T09:23:41.000+0000 | 17.0 | 2015-03-14T09:23:41.000+0000 | -74.01294708251953 | 40.705242156982415 | -73.98070526123048 | 40.74221420288086 | 6 |
| 2009-07-30T14:44:00.000+0000 | 5.3 | 2009-07-30T14:44:00.000+0000 | -73.978002 | 40.778607 | -73.970662 | 40.788625 | 1 |
| 2013-06-11T16:27:57.000+0000 | 10.0 | 2013-06-11T16:27:57.000+0000 | -73.995883 | 40.743785 | -73.990057 | 40.767137 | 1 |
| 2014-12-08T01:00:16.000+0000 | 15.5 | 2014-12-08T01:00:16.000+0000 | -73.957675 | 40.717887 | -73.942583 | 40.686397 | 1 |
| 2010-06-11T17:41:38.000+0000 | 6.9 | 2010-06-11T17:41:38.000+0000 | -73.977757 | 40.762991 | -73.983801 | 40.779518 | 1 |
| 2011-05-01T12:48:32.000+0000 | 18.1 | 2011-05-01T12:48:32.000+0000 | -73.986592 | 40.761807 | -74.010659 | 40.704133 | 1 |
| 2015-05-21T09:23:05.000+0000 | 15.5 | 2015-05-21T09:23:05.000+0000 | -73.9941177368164 | 40.75117874145508 | -73.97511291503906 | 40.7564582824707 | 1 |
| 2012-02-03T01:55:19.000+0000 | 10.1 | 2012-02-03T01:55:19.000+0000 | -73.982334 | 40.722411 | -73.964907 | 40.755644 | 1 |
| 2013-03-22T19:20:00.000+0000 | 21.5 | 2013-03-22T19:20:00.000+0000 | -73.955235 | 40.773077 | -74.007955 | 40.71711 | 6 |
| 2014-10-04T20:10:00.000+0000 | 8.5 | 2014-10-04T20:10:00.000+0000 | -73.99413 | 40.76668 | -73.98861 | 40.75705 | 1 |
| 2012-08-12T16:22:52.000+0000 | 7.3 | 2012-08-12T16:22:52.000+0000 | -73.988883 | 40.73405 | -73.992385 | 40.724842 | 1 |
| 2014-05-29T05:57:22.000+0000 | 2.5 | 2014-05-29T05:57:22.000+0000 | 0.0 | 0.0 | 0.0 | 0.0 | 1 |
| 2014-09-16T15:12:19.000+0000 | 8.5 | 2014-09-16T15:12:19.000+0000 | -73.958118 | 40.773086 | -73.946941 | 40.779994 | 1 |
| 2010-07-25T09:56:00.000+0000 | 6.1 | 2010-07-25T09:56:00.000+0000 | -73.970447 | 40.75779 | -73.969687 | 40.769923 | 5 |
| 2012-02-25T19:43:00.000+0000 | 14.1 | 2012-02-25T19:43:00.000+0000 | -73.981097 | 40.764483 | -73.99185 | 40.722037 | 1 |
| 2013-12-30T15:16:17.000+0000 | 6.0 | 2013-12-30T15:16:17.000+0000 | -73.9742 | 40.762693 | -73.979824 | 40.755547 | 1 |
| 2014-12-05T13:59:54.000+0000 | 8.5 | 2014-12-05T13:59:54.000+0000 | -73.958823 | 40.783588 | -73.978697 | 40.777533 | 1 |
| 2015-05-04T09:36:13.000+0000 | 8.0 | 2015-05-04T09:36:13.000+0000 | -73.98793029785155 | 40.72850036621094 | -74.00728607177734 | 40.72747802734375 | 1 |
| 2012-04-25T16:19:00.000+0000 | 5.3 | 2012-04-25T16:19:00.000+0000 | -73.971913 | 40.75925 | -73.962905 | 40.77216 | 1 |
| 2014-01-06T19:24:29.000+0000 | 10.5 | 2014-01-06T19:24:29.000+0000 | -73.978389 | 40.757757 | -73.980442 | 40.733626 | 1 |
| 2015-02-20T07:12:52.000+0000 | 5.5 | 2015-02-20T07:12:52.000+0000 | -73.97077941894531 | 40.75881576538086 | -73.97015380859375 | 40.74894332885742 | 1 |
| 2009-08-21T19:35:05.000+0000 | 8.1 | 2009-08-21T19:35:05.000+0000 | -73.960853 | 40.761557 | -73.976335 | 40.748361 | 1 |
| 2012-11-15T08:39:00.000+0000 | 13.0 | 2012-11-15T08:39:00.000+0000 | 0.0 | 0.0 | 0.0 | 0.0 | 1 |
| 2014-04-29T09:51:15.000+0000 | 8.5 | 2014-04-29T09:51:15.000+0000 | -73.99476 | 40.765585 | -73.996026 | 40.758698 | 1 |
| 2010-11-26T16:01:01.000+0000 | 6.1 | 2010-11-26T16:01:01.000+0000 | -73.953316 | 40.767588 | -73.971527 | 40.757499 | 1 |
| 2010-12-26T11:50:32.000+0000 | 12.9 | 2010-12-26T11:50:32.000+0000 | -73.975224 | 40.765201 | -73.998754 | 40.728 | 1 |
| 2014-02-01T21:06:00.000+0000 | 10.0 | 2014-02-01T21:06:00.000+0000 | -73.979022 | 40.777667 | -73.992172 | 40.721555 | 5 |
| 2014-07-08T20:16:00.000+0000 | 8.5 | 2014-07-08T20:16:00.000+0000 | -74.005547 | 40.745687 | -74.011247 | 40.728733 | 6 |
| 2010-04-15T18:13:00.000+0000 | 4.9 | 2010-04-15T18:13:00.000+0000 | -73.954665 | 40.773395 | -73.94686 | 40.776093 | 1 |
| 2012-09-26T13:14:47.000+0000 | 6.0 | 2012-09-26T13:14:47.000+0000 | -73.964483 | 40.764431 | -73.956576 | 40.779852 | 1 |
| 2014-01-10T08:16:07.000+0000 | 5.0 | 2014-01-10T08:16:07.000+0000 | -73.98214 | 40.772705 | -73.988691 | 40.774325 | 1 |
| 2014-03-12T18:12:44.000+0000 | 12.0 | 2014-03-12T18:12:44.000+0000 | -73.844904 | 40.736318 | -73.844904 | 40.736318 | 1 |
| 2013-03-02T15:47:27.000+0000 | 13.5 | 2013-03-02T15:47:27.000+0000 | -73.98265 | 40.753748 | -74.00793 | 40.741922 | 1 |
| 2015-03-11T14:48:58.000+0000 | 33.83 | 2015-03-11T14:48:58.000+0000 | -73.97330474853516 | 40.756385803222656 | -73.87244415283203 | 40.77430725097656 | 1 |
| 2009-09-02T05:18:10.000+0000 | 25.7 | 2009-09-02T05:18:10.000+0000 | -73.991729 | 40.760501 | -73.861246 | 40.767619 | 1 |
| 2010-05-21T08:35:00.000+0000 | 13.7 | 2010-05-21T08:35:00.000+0000 | -73.992128 | 40.739535 | -73.95814 | 40.768797 | 3 |
| 2011-10-16T22:37:25.000+0000 | 10.5 | 2011-10-16T22:37:25.000+0000 | -73.997265 | 40.719963 | -73.994268 | 40.754212 | 1 |
| 2012-03-07T11:26:12.000+0000 | 5.7 | 2012-03-07T11:26:12.000+0000 | -73.953871 | 40.766331 | -73.962465 | 40.774757 | 1 |
| 2013-08-24T17:07:00.000+0000 | 9.0 | 2013-08-24T17:07:00.000+0000 | -73.993372 | 40.736177 | -73.978277 | 40.75786 | 2 |
| 2014-02-06T11:17:00.000+0000 | 22.5 | 2014-02-06T11:17:00.000+0000 | -73.98071 | 40.782635 | -74.00204 | 40.719425 | 1 |
| 2014-02-06T11:17:00.000+0000 | 7.5 | 2014-02-06T11:17:00.000+0000 | -73.954463 | 40.769887 | -73.961627 | 40.77936 | 1 |
| 2011-04-20T18:51:56.000+0000 | 14.1 | 2011-04-20T18:51:56.000+0000 | -73.992131 | 40.724066 | -73.98057 | 40.762877 | 1 |
| 2012-05-03T21:28:00.000+0000 | 9.3 | 2012-05-03T21:28:00.000+0000 | -73.972108 | 40.759308 | -73.999263 | 40.761322 | 1 |
| 2014-02-22T18:41:34.000+0000 | 4.0 | 2014-02-22T18:41:34.000+0000 | -73.990366 | 40.757343 | -73.985373 | 40.760604 | 1 |
| 2014-10-03T16:31:00.000+0000 | 5.5 | 2014-10-03T16:31:00.000+0000 | -73.99223 | 40.725887 | -73.993782 | 40.735277 | 1 |
| 2009-05-18T12:30:00.000+0000 | 9.3 | 2009-05-18T12:30:00.000+0000 | -73.975782 | 40.74727 | -73.96611 | 40.762933 | 1 |
| 2010-06-26T09:59:00.000+0000 | 7.3 | 2010-06-26T09:59:00.000+0000 | -73.999627 | 40.743547 | -73.98927 | 40.756862 | 2 |
| 2013-06-20T12:36:08.000+0000 | 4.5 | 2013-06-20T12:36:08.000+0000 | -73.988446 | 40.770843 | -73.985985 | 40.777708 | 1 |
| 2013-09-12T11:32:00.000+0000 | 13.0 | 2013-09-12T11:32:00.000+0000 | -73.98206 | 40.772705 | -73.956213 | 40.771777 | 1 |
| 2010-04-10T16:56:00.000+0000 | 5.7 | 2010-04-10T16:56:00.000+0000 | -73.966422 | 40.767587 | -73.973363 | 40.75827 | 2 |
| 2014-11-15T13:12:56.000+0000 | 8.0 | 2014-11-15T13:12:56.000+0000 | -74.005382 | 40.749044 | -73.99412 | 40.761185 | 1 |
| 2015-05-20T20:29:35.000+0000 | 20.5 | 2015-05-20T20:29:35.000+0000 | -74.0115966796875 | 40.70290756225586 | -73.97222900390625 | 40.763145446777344 | 2 |
| 2011-10-16T11:37:46.000+0000 | 9.3 | 2011-10-16T11:37:46.000+0000 | -73.9927 | 40.7372 | -73.9683 | 40.7624 | 1 |
| 2011-10-21T08:18:49.000+0000 | 8.5 | 2011-10-21T08:18:49.000+0000 | -73.990387 | 40.73118 | -74.0021 | 40.70805 | 2 |
| 2012-03-24T22:13:00.000+0000 | 8.1 | 2012-03-24T22:13:00.000+0000 | -73.990138 | 40.740232 | -73.99523 | 40.718407 | 1 |
| 2013-12-09T09:16:00.000+0000 | 5.0 | 2013-12-09T09:16:00.000+0000 | -73.980617 | 40.74487 | -73.98711 | 40.749577 | 5 |
| 2009-01-16T05:58:00.000+0000 | 5.3 | 2009-01-16T05:58:00.000+0000 | -73.99201 | 40.755538 | -73.99796 | 40.755995 | 5 |
| 2010-04-21T13:39:00.000+0000 | 5.3 | 2010-04-21T13:39:00.000+0000 | -73.988323 | 40.722913 | -74.002315 | 40.729572 | 1 |
| 2011-07-01T08:24:00.000+0000 | 6.9 | 2011-07-01T08:24:00.000+0000 | -73.982628 | 40.771032 | -73.984127 | 40.748062 | 2 |
| 2014-10-21T07:04:06.000+0000 | 8.5 | 2014-10-21T07:04:06.000+0000 | -73.948403 | 40.78258 | -73.968905 | 40.787675 | 1 |
| 2012-07-02T08:43:33.000+0000 | 6.5 | 2012-07-02T08:43:33.000+0000 | -73.975256 | 40.756147 | -73.960543 | 40.775509 | 1 |
| 2012-09-15T02:17:00.000+0000 | 29.0 | 2012-09-15T02:17:00.000+0000 | -74.00324 | 40.733577 | -73.94855 | 40.723342 | 1 |
| 2014-01-29T22:41:00.000+0000 | 21.0 | 2014-01-29T22:41:00.000+0000 | -73.978553 | 40.766717 | -74.016195 | 40.711052 | 6 |
| 2009-01-02T10:13:46.000+0000 | 14.5 | 2009-01-02T10:13:46.000+0000 | -73.947043 | 40.780107 | -73.989034 | 40.751587 | 2 |
| 2009-09-12T10:56:00.000+0000 | 32.9 | 2009-09-12T10:56:00.000+0000 | -73.982762 | 40.769003 | -73.87262 | 40.774533 | 1 |
| 2011-05-17T07:53:19.000+0000 | 6.1 | 2011-05-17T07:53:19.000+0000 | -73.978292 | 40.782962 | -73.961085 | 40.806684 | 1 |
| 2013-11-07T10:19:35.000+0000 | 13.0 | 2013-11-07T10:19:35.000+0000 | -73.985802 | 40.777477 | -73.987414 | 40.754369 | 1 |
| 2014-07-11T12:24:43.000+0000 | 15.0 | 2014-07-11T12:24:43.000+0000 | -73.9942 | 40.751005 | -73.97559 | 40.759188 | 1 |
| 2010-02-03T14:33:29.000+0000 | 4.9 | 2010-02-03T14:33:29.000+0000 | -73.968848 | 40.759129 | -73.976118 | 40.765747 | 1 |
| 2010-11-11T21:18:00.000+0000 | 8.9 | 2010-11-11T21:18:00.000+0000 | -73.981872 | 40.760252 | -74.002232 | 40.740567 | 5 |
| 2012-04-05T20:19:03.000+0000 | 8.1 | 2012-04-05T20:19:03.000+0000 | -73.993127 | 40.736777 | -74.010699 | 40.720116 | 1 |
| 2013-04-30T16:25:36.000+0000 | 6.0 | 2013-04-30T16:25:36.000+0000 | -73.986575 | 40.75505 | -73.980971 | 40.765857 | 1 |
| 2014-05-12T23:31:00.000+0000 | 57.33 | 2014-05-12T23:31:00.000+0000 | -73.79025 | 40.643705 | -74.00227 | 40.734542 | 1 |
| 2014-05-20T13:15:00.000+0000 | 8.0 | 2014-05-20T13:15:00.000+0000 | -73.974292 | 40.793455 | -73.978205 | 40.778272 | 1 |
| 2009-11-28T17:12:00.000+0000 | 8.5 | 2009-11-28T17:12:00.000+0000 | -73.959937 | 40.780397 | -73.974948 | 40.798193 | 1 |
| 2010-01-31T15:21:08.000+0000 | 8.9 | 2010-01-31T15:21:08.000+0000 | -73.976061 | 40.75818 | -73.948436 | 40.78255 | 1 |
| 2010-08-06T09:29:00.000+0000 | 10.5 | 2010-08-06T09:29:00.000+0000 | -73.96501 | 40.769925 | -73.968125 | 40.778048 | 5 |
| 2010-09-08T15:14:00.000+0000 | 10.1 | 2010-09-08T15:14:00.000+0000 | -74.010347 | 40.720153 | -73.99492 | 40.769032 | 2 |
| 2011-11-15T13:07:50.000+0000 | 49.8 | 2011-11-15T13:07:50.000+0000 | -73.983851 | 40.761851 | -73.783129 | 40.643785 | 3 |
| 2015-02-01T17:24:59.000+0000 | 5.0 | 2015-02-01T17:24:59.000+0000 | -73.98371124267578 | 40.74961853027344 | -73.99261474609375 | 40.74286651611328 | 1 |
| 2015-02-16T17:12:44.000+0000 | 6.0 | 2015-02-16T17:12:44.000+0000 | -73.9576187133789 | 40.76677322387695 | -73.95582580566406 | 40.77876663208008 | 1 |
| 2010-02-26T23:56:00.000+0000 | 13.3 | 2010-02-26T23:56:00.000+0000 | -73.99771 | 40.756485 | -73.987518 | 40.721337 | 1 |
| 2015-04-09T07:20:46.000+0000 | 7.0 | 2015-04-09T07:20:46.000+0000 | -73.9783477783203 | 40.76491165161133 | -73.98352813720702 | 40.76810836791992 | 1 |
| 2012-03-28T13:09:20.000+0000 | 10.5 | 2012-03-28T13:09:20.000+0000 | -73.999733 | 40.73322 | -73.985659 | 40.759156 | 2 |
| 2012-12-21T13:10:00.000+0000 | 56.8 | 2012-12-21T13:10:00.000+0000 | -73.978817 | 40.761517 | -73.789255 | 40.642677 | 1 |
| 2013-12-04T18:13:00.000+0000 | 14.5 | 2013-12-04T18:13:00.000+0000 | -73.984045 | 40.748432 | -74.009758 | 40.722695 | 1 |
| 2010-11-25T22:54:00.000+0000 | 11.3 | 2010-11-25T22:54:00.000+0000 | -74.005448 | 40.725823 | -74.005942 | 40.725048 | 2 |
| 2011-01-14T17:22:12.000+0000 | 6.5 | 2011-01-14T17:22:12.000+0000 | -73.970799 | 40.751642 | -73.980333 | 40.748303 | 1 |
| 2011-06-02T14:04:00.000+0000 | 5.7 | 2011-06-02T14:04:00.000+0000 | -73.99171 | 40.731902 | -73.97907 | 40.745213 | 1 |
| 2013-05-02T01:22:00.000+0000 | 13.0 | 2013-05-02T01:22:00.000+0000 | -73.961407 | 40.716362 | -73.994242 | 40.694847 | 1 |
| 2014-07-03T01:34:00.000+0000 | 22.0 | 2014-07-03T01:34:00.000+0000 | -73.968087 | 40.75514 | -73.952622 | 40.823312 | 5 |
| 2011-11-10T00:09:07.000+0000 | 18.5 | 2011-11-10T00:09:07.000+0000 | -73.980992 | 40.744531 | -73.948478 | 40.778086 | 1 |
| 2012-06-17T18:08:12.000+0000 | 14.1 | 2012-06-17T18:08:12.000+0000 | -73.957312 | 40.776963 | -73.990408 | 40.751271 | 2 |
| 2010-01-09T21:28:55.000+0000 | 4.5 | 2010-01-09T21:28:55.000+0000 | -73.952804 | 40.782491 | -73.961038 | 40.774978 | 2 |
| 2014-07-20T11:49:33.000+0000 | 24.0 | 2014-07-20T11:49:33.000+0000 | -73.874483 | 40.774095 | -73.967098 | 40.711603 | 1 |
| 2010-01-16T13:58:13.000+0000 | 25.7 | 2010-01-16T13:58:13.000+0000 | -73.979952 | 40.726656 | -73.951914 | 40.813041 | 1 |
| 2011-08-30T10:09:03.000+0000 | 3.3 | 2011-08-30T10:09:03.000+0000 | -73.998082 | 40.741128 | -73.993909 | 40.739392 | 1 |
| 2012-03-26T05:47:15.000+0000 | 8.5 | 2012-03-26T05:47:15.000+0000 | -73.954353 | 40.779059 | -73.985525 | 40.755313 | 1 |
| 2010-07-31T22:00:38.000+0000 | 5.3 | 2010-07-31T22:00:38.000+0000 | -74.003192 | 40.732796 | -73.999881 | 40.719227 | 1 |
| 2011-06-12T01:48:00.000+0000 | 4.5 | 2011-06-12T01:48:00.000+0000 | -73.982442 | 40.742135 | -73.992495 | 40.738278 | 1 |
| 2009-01-11T22:50:00.000+0000 | 3.7 | 2009-01-11T22:50:00.000+0000 | -73.987127 | 40.733377 | -73.981355 | 40.74125 | 2 |
| 2011-07-26T11:56:41.000+0000 | 8.1 | 2011-07-26T11:56:41.000+0000 | -73.976809 | 40.775044 | -73.967976 | 40.762807 | 1 |
| 2010-08-03T14:58:00.000+0000 | 16.1 | 2010-08-03T14:58:00.000+0000 | -74.00461 | 40.716322 | -74.003732 | 40.658428 | 2 |
| 2011-05-22T00:30:32.000+0000 | 12.9 | 2011-05-22T00:30:32.000+0000 | -73.979746 | 40.781009 | -73.980523 | 40.738272 | 1 |
| 2011-08-20T13:40:33.000+0000 | 8.1 | 2011-08-20T13:40:33.000+0000 | -73.989393 | 40.726381 | -73.997417 | 40.714365 | 2 |
| 2013-03-14T11:13:00.000+0000 | 9.5 | 2013-03-14T11:13:00.000+0000 | -73.957788 | 40.781995 | -73.96262 | 40.764742 | 1 |
| 2014-09-02T00:02:00.000+0000 | 23.5 | 2014-09-02T00:02:00.000+0000 | -73.944145 | 40.702737 | -73.913985 | 40.77846 | 2 |
| 2009-02-22T22:48:00.000+0000 | 2.5 | 2009-02-22T22:48:00.000+0000 | 0.0 | 0.0 | -74.005433 | 40.726685 | 2 |
| 2009-03-28T20:05:13.000+0000 | 11.0 | 2009-03-28T20:05:13.000+0000 | -73.95822 | 40.768717 | -73.989314 | 40.739968 | 1 |
| 2011-10-10T18:31:34.000+0000 | 6.1 | 2011-10-10T18:31:34.000+0000 | -73.984847 | 40.761632 | -73.965846 | 40.754548 | 2 |
| 2014-07-13T11:15:00.000+0000 | 28.0 | 2014-07-13T11:15:00.000+0000 | -73.87093 | 40.773787 | -73.966003 | 40.755425 | 1 |
| 2014-07-23T08:42:00.000+0000 | 10.0 | 2014-07-23T08:42:00.000+0000 | -73.99276 | 40.751162 | -73.98098 | 40.752827 | 1 |
| 2009-04-03T11:58:00.000+0000 | 10.1 | 2009-04-03T11:58:00.000+0000 | -73.987997 | 40.737872 | -73.988583 | 40.757525 | 1 |
| 2011-04-30T04:15:00.000+0000 | 7.7 | 2011-04-30T04:15:00.000+0000 | -73.982377 | 40.739743 | -73.959688 | 40.758598 | 5 |
| 2014-03-26T22:46:23.000+0000 | 8.0 | 2014-03-26T22:46:23.000+0000 | -73.976248 | 40.760885 | -73.991236 | 40.750376 | 1 |
| 2009-07-16T18:04:00.000+0000 | 6.1 | 2009-07-16T18:04:00.000+0000 | -73.953432 | 40.766765 | -73.968447 | 40.7649 | 1 |
| 2012-09-13T11:31:00.000+0000 | 20.5 | 2012-09-13T11:31:00.000+0000 | -73.98646 | 40.751527 | -73.953732 | 40.787725 | 1 |
| 2013-11-19T10:38:00.000+0000 | 9.5 | 2013-11-19T10:38:00.000+0000 | -74.003197 | 40.744075 | -74.00067 | 40.726062 | 1 |
| 2014-02-14T05:55:36.000+0000 | 7.0 | 2014-02-14T05:55:36.000+0000 | -73.95893 | 40.763626 | -73.973753 | 40.759813 | 1 |
| 2011-07-13T07:32:00.000+0000 | 8.5 | 2011-07-13T07:32:00.000+0000 | -73.98732 | 40.738957 | -74.004458 | 40.707322 | 1 |
| 2014-05-30T21:44:34.000+0000 | 7.5 | 2014-05-30T21:44:34.000+0000 | -73.964127 | 40.792641 | -73.979984 | 40.782037 | 2 |
| 2015-06-22T19:04:41.000+0000 | 11.5 | 2015-06-22T19:04:41.000+0000 | -73.95744323730467 | 40.76170349121094 | -73.97323608398438 | 40.78707885742188 | 1 |
| 2010-04-29T08:27:00.000+0000 | 7.7 | 2010-04-29T08:27:00.000+0000 | -73.998418 | 40.735472 | -74.01432 | 40.713072 | 1 |
| 2011-12-14T20:47:00.000+0000 | 6.1 | 2011-12-14T20:47:00.000+0000 | -73.978192 | 40.745775 | -73.975422 | 40.73007 | 2 |
| 2012-09-02T23:09:00.000+0000 | 38.5 | 2012-09-02T23:09:00.000+0000 | -73.977473 | 40.746538 | -73.851405 | 40.689473 | 2 |
| 2015-05-28T11:56:51.000+0000 | 11.5 | 2015-05-28T11:56:51.000+0000 | -73.9819564819336 | 40.76792144775391 | -73.97608947753906 | 40.795188903808594 | 2 |
| 2012-09-24T23:07:15.000+0000 | 6.0 | 2012-09-24T23:07:15.000+0000 | -73.980914 | 40.779513 | -73.970524 | 40.796703 | 1 |
| 2013-05-02T18:59:25.000+0000 | 17.0 | 2013-05-02T18:59:25.000+0000 | -74.016361 | 40.712852 | -73.984364 | 40.729531 | 1 |
| 2014-08-15T21:24:00.000+0000 | 7.5 | 2014-08-15T21:24:00.000+0000 | -73.988477 | 40.739202 | -74.001812 | 40.740582 | 1 |
| 2015-05-16T11:33:57.000+0000 | 5.5 | 2015-05-16T11:33:57.000+0000 | -73.97361755371094 | 40.78464126586913 | -73.97045135498048 | 40.796119689941406 | 1 |
| 2011-03-20T17:25:00.000+0000 | 6.9 | 2011-03-20T17:25:00.000+0000 | -73.979605 | 40.752025 | -73.993742 | 40.756685 | 1 |
| 2013-02-15T12:13:00.000+0000 | 3.0 | 2013-02-15T12:13:00.000+0000 | -73.994313 | 40.735362 | -73.997212 | 40.73681 | 1 |
| 2014-03-03T19:03:42.000+0000 | 12.5 | 2014-03-03T19:03:42.000+0000 | -73.998881 | 40.734511 | -73.971341 | 40.760929 | 1 |
| 2009-03-16T04:47:17.000+0000 | 17.0 | 2009-03-16T04:47:17.000+0000 | 0.0 | 0.0 | 0.0 | 0.0 | 1 |
| 2012-11-30T11:02:00.000+0000 | 38.8 | 2012-11-30T11:02:00.000+0000 | -73.97462 | 40.756922 | -73.864002 | 40.767872 | 1 |
| 2013-03-10T04:12:00.000+0000 | 6.0 | 2013-03-10T04:12:00.000+0000 | -74.000405 | 40.71857 | -74.00004 | 40.726592 | 1 |
| 2014-06-18T07:38:20.000+0000 | 6.5 | 2014-06-18T07:38:20.000+0000 | -73.980695 | 40.742047 | -73.97293 | 40.759006 | 1 |
| 2014-08-01T01:59:00.000+0000 | 14.5 | 2014-08-01T01:59:00.000+0000 | -73.977567 | 40.778957 | -73.991272 | 40.72782 | 1 |
| 2010-01-19T01:10:00.000+0000 | 2.5 | 2010-01-19T01:10:00.000+0000 | -73.99872 | 40.624708 | -73.99872 | 40.624708 | 1 |
| 2009-04-10T17:32:00.000+0000 | 4.1 | 2009-04-10T17:32:00.000+0000 | -73.993962 | 40.735152 | -74.00358 | 40.732207 | 1 |
| 2010-08-21T14:22:57.000+0000 | 13.3 | 2010-08-21T14:22:57.000+0000 | -74.005752 | 40.717735 | -73.962639 | 40.766952 | 2 |
| 2012-12-08T23:27:00.000+0000 | 6.0 | 2012-12-08T23:27:00.000+0000 | -74.003502 | 40.738745 | -73.993317 | 40.752022 | 3 |
| 2013-01-16T16:40:00.000+0000 | 6.5 | 2013-01-16T16:40:00.000+0000 | -73.987437 | 40.738262 | -73.975865 | 40.74594 | 1 |
| 2013-03-25T11:32:32.000+0000 | 12.5 | 2013-03-25T11:32:32.000+0000 | -74.006545 | 40.716519 | -73.993427 | 40.752308 | 1 |
| 2014-05-09T12:55:00.000+0000 | 21.5 | 2014-05-09T12:55:00.000+0000 | -73.965747 | 40.77121 | -74.005188 | 40.729157 | 1 |
| 2010-10-23T18:39:00.000+0000 | 49.57 | 2010-10-23T18:39:00.000+0000 | -73.782215 | 40.644272 | -73.782217 | 40.64427 | 2 |
| 2010-11-13T04:38:00.000+0000 | 38.1 | 2010-11-13T04:38:00.000+0000 | -74.00761 | 40.725875 | -73.867393 | 40.859275 | 1 |
| 2011-07-10T02:08:08.000+0000 | 10.1 | 2011-07-10T02:08:08.000+0000 | -73.993027 | 40.725563 | -73.958591 | 40.717069 | 1 |
| 2010-04-28T18:58:00.000+0000 | 4.5 | 2010-04-28T18:58:00.000+0000 | -73.966902 | 40.76209 | -73.972658 | 40.761098 | 1 |
| 2011-12-17T13:53:00.000+0000 | 5.3 | 2011-12-17T13:53:00.000+0000 | -73.987885 | 40.749152 | -73.975165 | 40.759095 | 3 |
| 2013-10-31T23:44:00.000+0000 | 8.0 | 2013-10-31T23:44:00.000+0000 | -74.004978 | 40.719012 | -74.006807 | 40.706832 | 1 |
| 2009-07-30T21:24:21.000+0000 | 7.7 | 2009-07-30T21:24:21.000+0000 | -73.999556 | 40.738662 | -73.979409 | 40.727603 | 1 |
| 2012-10-01T09:02:00.000+0000 | 7.5 | 2012-10-01T09:02:00.000+0000 | -73.986717 | 40.76152 | -73.968675 | 40.796662 | 2 |
| 2015-03-17T13:30:23.000+0000 | 5.5 | 2015-03-17T13:30:23.000+0000 | -73.95622253417967 | 40.78130722045898 | -73.95951080322266 | 40.77655029296875 | 1 |
| 2009-03-01T18:37:49.000+0000 | 7.7 | 2009-03-01T18:37:49.000+0000 | -73.997631 | 40.724238 | -74.009196 | 40.710869 | 1 |
| 2010-02-12T21:30:03.000+0000 | 8.1 | 2010-02-12T21:30:03.000+0000 | -73.978894 | 40.763859 | -73.946947 | 40.779657 | 1 |
| 2014-07-12T13:17:34.000+0000 | 5.5 | 2014-07-12T13:17:34.000+0000 | -73.976995 | 40.763962 | -73.978033 | 40.757489 | 1 |
| 2015-06-13T07:19:10.000+0000 | 6.5 | 2015-06-13T07:19:10.000+0000 | -73.98194122314453 | 40.74060821533203 | -73.99118041992188 | 40.74890899658203 | 1 |
| 2013-08-06T23:24:46.000+0000 | 4.5 | 2013-08-06T23:24:46.000+0000 | -73.99758 | 40.729132 | -73.991998 | 40.725226 | 1 |
| 2013-09-24T18:23:52.000+0000 | 7.0 | 2013-09-24T18:23:52.000+0000 | -73.945542 | 40.774462 | -73.957452 | 40.783008 | 1 |
| 2014-02-19T12:48:00.000+0000 | 17.5 | 2014-02-19T12:48:00.000+0000 | -73.961757 | 40.76281 | -73.999328 | 40.7493 | 1 |
| 2011-02-13T14:48:57.000+0000 | 4.9 | 2011-02-13T14:48:57.000+0000 | -73.96498 | 40.759943 | -73.971154 | 40.764252 | 2 |
| 2013-06-01T12:53:00.000+0000 | 6.0 | 2013-06-01T12:53:00.000+0000 | -73.963967 | 40.808232 | -73.972693 | 40.793455 | 1 |
| 2010-03-11T20:59:00.000+0000 | 4.5 | 2010-03-11T20:59:00.000+0000 | -73.99303 | 40.762935 | -73.99059 | 40.757643 | 5 |
| 2014-09-22T11:58:00.000+0000 | 10.5 | 2014-09-22T11:58:00.000+0000 | -73.97248 | 40.784842 | -73.954747 | 40.775662 | 1 |
| 2010-02-17T22:51:00.000+0000 | 8.9 | 2010-02-17T22:51:00.000+0000 | -74.005798 | 40.741247 | -74.01719 | 40.705187 | 1 |
| 2010-02-28T16:56:00.000+0000 | 6.1 | 2010-02-28T16:56:00.000+0000 | -74.00186 | 40.737772 | -74.009763 | 40.714795 | 5 |
| 2010-08-07T13:46:00.000+0000 | 14.5 | 2010-08-07T13:46:00.000+0000 | -74.002285 | 40.73961 | -73.952757 | 40.779637 | 1 |
| 2010-10-23T12:11:31.000+0000 | 6.1 | 2010-10-23T12:11:31.000+0000 | -73.993656 | 40.74735 | -73.982864 | 40.742636 | 2 |
| 2012-03-15T23:48:00.000+0000 | 5.7 | 2012-03-15T23:48:00.000+0000 | -73.954327 | 40.764005 | -73.956155 | 40.775967 | 1 |
| 2013-01-13T13:38:00.000+0000 | 8.0 | 2013-01-13T13:38:00.000+0000 | -73.989647 | 40.74729 | -73.985648 | 40.735408 | 5 |
| 2013-05-25T15:46:29.000+0000 | 5.5 | 2013-05-25T15:46:29.000+0000 | -73.963307 | 40.798379 | -73.97504 | 40.78278 | 1 |
| 2014-09-10T12:09:01.000+0000 | 52.0 | 2014-09-10T12:09:01.000+0000 | -73.985722 | 40.749696 | -73.973577 | 40.74901 | 1 |
| 2011-04-18T11:58:00.000+0000 | 49.8 | 2011-04-18T11:58:00.000+0000 | -73.972822 | 40.793295 | -73.782862 | 40.64395 | 2 |
| 2012-04-22T17:10:00.000+0000 | 49.8 | 2012-04-22T17:10:00.000+0000 | -73.95403 | 40.74158 | -73.995527 | 40.742962 | 1 |
| 2013-10-29T01:09:14.000+0000 | 16.0 | 2013-10-29T01:09:14.000+0000 | 0.0 | 0.0 | 0.0 | 0.0 | 1 |
| 2014-07-07T13:52:00.000+0000 | 16.5 | 2014-07-07T13:52:00.000+0000 | -73.979962 | 40.759952 | -73.99467 | 40.723662 | 1 |
| 2009-12-29T14:23:00.000+0000 | 4.5 | 2009-12-29T14:23:00.000+0000 | 0.0 | 0.0 | 0.0 | 0.0 | 1 |
| 2010-04-16T17:02:00.000+0000 | 11.3 | 2010-04-16T17:02:00.000+0000 | -73.972412 | 40.78123 | -73.989187 | 40.758375 | 5 |
| 2012-11-10T12:37:00.000+0000 | 10.0 | 2012-11-10T12:37:00.000+0000 | -73.947073 | 40.779932 | -73.96799 | 40.765642 | 2 |
| 2012-11-11T03:12:00.000+0000 | 16.5 | 2012-11-11T03:12:00.000+0000 | -74.003815 | 40.743057 | -73.948877 | 40.778277 | 1 |
| 2009-09-13T12:47:43.000+0000 | 8.9 | 2009-09-13T12:47:43.000+0000 | -73.996439 | 40.725517 | -73.976375 | 40.751634 | 2 |
| 2011-02-22T13:35:00.000+0000 | 6.9 | 2011-02-22T13:35:00.000+0000 | -73.971638 | 40.763382 | -73.953767 | 40.783715 | 1 |
| 2013-01-22T23:26:29.000+0000 | 5.0 | 2013-01-22T23:26:29.000+0000 | -73.921155 | 40.766861 | -73.913181 | 40.765184 | 1 |
| 2014-06-01T02:24:00.000+0000 | 4.0 | 2014-06-01T02:24:00.000+0000 | -73.991992 | 40.714875 | -73.997173 | 40.714412 | 1 |
| 2009-03-18T09:02:00.000+0000 | 5.7 | 2009-03-18T09:02:00.000+0000 | -73.977655 | 40.748835 | -73.991915 | 40.754223 | 1 |
| 2011-04-22T09:02:09.000+0000 | 2.9 | 2011-04-22T09:02:09.000+0000 | -73.964774 | 40.772788 | -73.963266 | 40.774752 | 1 |
| 2012-10-17T05:35:00.000+0000 | 52.0 | 2012-10-17T05:35:00.000+0000 | -73.789985 | 40.646382 | -74.03497 | 40.611455 | 1 |
| 2013-07-21T11:22:00.000+0000 | 10.5 | 2013-07-21T11:22:00.000+0000 | -73.959742 | 40.773777 | -73.988177 | 40.748772 | 1 |
| 2013-08-05T15:08:42.000+0000 | 38.83 | 2013-08-05T15:08:42.000+0000 | -73.97881 | 40.764147 | -73.86535 | 40.770732 | 3 |
| 2013-09-17T21:21:00.000+0000 | 4.5 | 2013-09-17T21:21:00.000+0000 | -74.000125 | 40.747762 | -74.005557 | 40.73871 | 5 |
| 2014-10-25T02:16:35.000+0000 | 7.0 | 2014-10-25T02:16:35.000+0000 | -73.992318 | 40.724933 | -73.981101 | 40.741954 | 1 |
| 2010-02-03T20:51:29.000+0000 | 12.9 | 2010-02-03T20:51:29.000+0000 | -73.954191 | 40.764029 | -73.918043 | 40.766876 | 1 |
| 2011-03-20T21:39:21.000+0000 | 7.3 | 2011-03-20T21:39:21.000+0000 | -73.978279 | 40.724843 | -74.00277 | 40.723674 | 2 |
| 2011-04-08T23:29:49.000+0000 | 4.9 | 2011-04-08T23:29:49.000+0000 | -73.985125 | 40.74187 | -73.996269 | 40.737978 | 1 |
| 2013-04-22T10:52:53.000+0000 | 5.5 | 2013-04-22T10:52:53.000+0000 | -73.983752 | 40.737981 | -73.975042 | 40.748834 | 1 |
| 2013-07-31T10:49:00.000+0000 | 13.5 | 2013-07-31T10:49:00.000+0000 | -73.963305 | 40.757785 | -73.945842 | 40.781722 | 1 |
| 2014-05-01T14:20:00.000+0000 | 22.0 | 2014-05-01T14:20:00.000+0000 | -74.016847 | 40.704765 | -73.975607 | 40.748965 | 1 |
| 2014-08-05T20:46:20.000+0000 | 11.0 | 2014-08-05T20:46:20.000+0000 | -73.873207 | 40.774149 | -73.920299 | 40.764046 | 1 |
| 2009-01-29T20:49:03.000+0000 | 5.0 | 2009-01-29T20:49:03.000+0000 | -73.995414 | 40.733265 | -73.991471 | 40.727619 | 1 |
| 2010-12-24T19:14:07.000+0000 | 9.7 | 2010-12-24T19:14:07.000+0000 | -74.008163 | 40.73873 | -73.9903 | 40.767205 | 1 |
| 2012-01-28T21:33:18.000+0000 | 4.9 | 2012-01-28T21:33:18.000+0000 | -73.955322 | 40.78284 | -73.955797 | 40.773673 | 0 |
| 2013-04-19T23:05:47.000+0000 | 9.5 | 2013-04-19T23:05:47.000+0000 | -74.004614 | 40.724284 | -73.977553 | 40.746468 | 1 |
| 2014-10-08T06:49:18.000+0000 | 6.5 | 2014-10-08T06:49:18.000+0000 | 0.0 | 0.0 | 0.0 | 0.0 | 1 |
| 2015-06-16T14:28:22.000+0000 | 8.5 | 2015-06-16T14:28:22.000+0000 | -73.95664978027344 | 40.77500915527344 | -73.96678924560547 | 40.76708221435546 | 6 |
| 2012-09-21T14:04:49.000+0000 | 5.5 | 2012-09-21T14:04:49.000+0000 | -73.98101 | 40.78174 | -73.989225 | 40.77622 | 1 |
| 2014-06-17T22:48:00.000+0000 | 10.5 | 2014-06-17T22:48:00.000+0000 | -73.978015 | 40.759927 | -73.956005 | 40.768142 | 1 |
| 2009-01-06T22:30:00.000+0000 | 4.5 | 2009-01-06T22:30:00.000+0000 | -73.998965 | 40.73831 | -73.997162 | 40.747027 | 2 |
| 2009-12-31T22:27:00.000+0000 | 4.9 | 2009-12-31T22:27:00.000+0000 | -73.996958 | 40.722988 | -74.005807 | 40.726383 | 5 |
| 2010-07-02T16:58:45.000+0000 | 7.3 | 2010-07-02T16:58:45.000+0000 | -73.978321 | 40.753844 | -73.982309 | 40.777037 | 1 |
| 2011-02-02T07:52:21.000+0000 | 5.3 | 2011-02-02T07:52:21.000+0000 | -74.006924 | 40.703967 | -74.012995 | 40.705742 | 1 |
| 2011-02-04T18:43:06.000+0000 | 14.1 | 2011-02-04T18:43:06.000+0000 | -74.003605 | 40.720436 | -73.985766 | 40.759837 | 1 |
| 2014-06-02T08:31:14.000+0000 | 6.5 | 2014-06-02T08:31:14.000+0000 | -73.966418 | 40.770348 | -73.955528 | 40.76583 | 1 |
| 2010-03-25T10:20:00.000+0000 | 3.7 | 2010-03-25T10:20:00.000+0000 | -73.994448 | 40.690077 | -73.988643 | 40.693565 | 3 |
| 2012-02-24T18:44:00.000+0000 | 11.7 | 2012-02-24T18:44:00.000+0000 | -73.953996 | 40.770532 | -73.986594 | 40.742354 | 1 |
| 2014-01-04T21:11:00.000+0000 | 9.0 | 2014-01-04T21:11:00.000+0000 | -73.97764 | 40.752347 | -73.970392 | 40.768867 | 2 |
| 2009-04-08T08:52:00.000+0000 | 10.1 | 2009-04-08T08:52:00.000+0000 | -73.974353 | 40.763542 | -73.990128 | 40.732237 | 1 |
| 2012-02-17T08:14:00.000+0000 | 49.8 | 2012-02-17T08:14:00.000+0000 | -73.788127 | 40.647295 | -73.978957 | 40.756305 | 5 |
| 2012-04-18T19:08:00.000+0000 | 8.1 | 2012-04-18T19:08:00.000+0000 | -74.000338 | 40.717538 | -74.00771 | 40.705213 | 1 |
| 2009-05-11T08:16:13.000+0000 | 7.3 | 2009-05-11T08:16:13.000+0000 | -73.968412 | 40.786347 | -73.952285 | 40.789819 | 1 |
| 2011-05-16T23:10:43.000+0000 | 5.7 | 2011-05-16T23:10:43.000+0000 | -73.984797 | 40.763133 | -73.975928 | 40.765276 | 2 |
| 2011-12-03T20:56:00.000+0000 | 10.5 | 2011-12-03T20:56:00.000+0000 | -74.001972 | 40.734998 | -73.981498 | 40.743742 | 1 |
| 2012-03-23T19:13:00.000+0000 | 8.1 | 2012-03-23T19:13:00.000+0000 | -73.962563 | 40.79985 | -73.98419 | 40.770172 | 5 |
| 2012-09-19T09:22:56.000+0000 | 28.5 | 2012-09-19T09:22:56.000+0000 | -73.952827 | 40.772524 | -74.000287 | 40.75857 | 1 |
| 2010-04-16T19:12:00.000+0000 | 14.9 | 2010-04-16T19:12:00.000+0000 | -73.982682 | 40.775085 | -74.00731 | 40.741228 | 2 |
| 2011-10-25T14:19:00.000+0000 | 13.7 | 2011-10-25T14:19:00.000+0000 | -73.964307 | 40.773437 | -73.989902 | 40.735977 | 1 |
| 2012-03-16T18:02:35.000+0000 | 7.3 | 2012-03-16T18:02:35.000+0000 | -73.981596 | 40.769859 | -73.9746 | 40.760504 | 1 |
| 2014-03-28T07:03:26.000+0000 | 5.5 | 2014-03-28T07:03:26.000+0000 | -73.968589 | 40.75909 | -73.97673 | 40.759161 | 1 |
| 2013-12-04T08:44:06.000+0000 | 11.5 | 2013-12-04T08:44:06.000+0000 | -73.982061 | 40.775128 | -73.974957 | 40.759715 | 1 |
| 2015-01-14T20:54:03.000+0000 | 8.0 | 2015-01-14T20:54:03.000+0000 | -73.97602081298828 | 40.7550163269043 | -73.99665069580078 | 40.76326370239258 | 1 |
| 2009-01-09T14:41:24.000+0000 | 4.9 | 2009-01-09T14:41:24.000+0000 | -73.958259 | 40.768903 | -73.954744 | 40.779351 | 1 |
| 2010-04-20T21:39:00.000+0000 | 3.7 | 2010-04-20T21:39:00.000+0000 | -73.987802 | 40.752183 | -73.985067 | 40.747572 | 1 |
| 2012-12-24T23:12:00.000+0000 | 13.5 | 2012-12-24T23:12:00.000+0000 | -73.973522 | 40.792337 | -73.942002 | 40.822752 | 5 |
| 2011-03-01T08:53:00.000+0000 | 10.5 | 2011-03-01T08:53:00.000+0000 | -74.006277 | 40.73306 | -73.977088 | 40.771765 | 1 |
| 2014-05-15T18:23:00.000+0000 | 10.0 | 2014-05-15T18:23:00.000+0000 | -73.962393 | 40.778807 | -73.979503 | 40.771362 | 2 |
| 2014-08-12T03:11:51.000+0000 | 11.5 | 2014-08-12T03:11:51.000+0000 | -74.00406 | 40.741953 | -73.979982 | 40.762617 | 2 |
| 2014-09-03T18:08:00.000+0000 | 16.0 | 2014-09-03T18:08:00.000+0000 | -74.00696 | 40.75149 | -74.00058 | 40.7211 | 1 |
| 2009-07-25T15:42:18.000+0000 | 8.9 | 2009-07-25T15:42:18.000+0000 | -73.957668 | 40.77933 | -73.983479 | 40.76042 | 2 |
| 2012-11-14T17:19:00.000+0000 | 4.5 | 2012-11-14T17:19:00.000+0000 | -73.981177 | 40.779345 | -73.973628 | 40.789612 | 1 |
| 2014-05-04T17:30:29.000+0000 | 9.5 | 2014-05-04T17:30:29.000+0000 | -74.005328 | 40.721161 | -73.984595 | 40.742348 | 1 |
| 2010-01-20T11:21:00.000+0000 | 5.3 | 2010-01-20T11:21:00.000+0000 | -74.010468 | 40.703142 | -73.999873 | 40.71414 | 5 |
| 2010-04-27T06:04:37.000+0000 | 4.1 | 2010-04-27T06:04:37.000+0000 | -73.961373 | 40.760497 | -73.954164 | 40.764079 | 1 |
| 2011-03-03T07:40:59.000+0000 | 8.1 | 2011-03-03T07:40:59.000+0000 | -74.007816 | 40.733536 | -73.986556 | 40.74004 | 1 |
| 2011-12-16T08:40:00.000+0000 | 18.1 | 2011-12-16T08:40:00.000+0000 | -74.007673 | 40.705285 | -73.974562 | 40.763668 | 1 |
| 2012-07-10T13:13:07.000+0000 | 9.7 | 2012-07-10T13:13:07.000+0000 | -73.991003 | 40.733332 | -73.986998 | 40.747792 | 1 |
| 2012-10-22T10:43:00.000+0000 | 6.0 | 2012-10-22T10:43:00.000+0000 | -73.968658 | 40.770303 | -73.982578 | 40.774702 | 1 |
| 2014-02-12T08:04:10.000+0000 | 5.0 | 2014-02-12T08:04:10.000+0000 | -73.966568 | 40.795888 | -73.970033 | 40.787512 | 1 |
| 2012-01-30T13:25:00.000+0000 | 6.9 | 2012-01-30T13:25:00.000+0000 | -73.983952 | 40.74928 | -73.97778 | 40.737878 | 2 |
| 2014-04-25T19:37:49.000+0000 | 14.5 | 2014-04-25T19:37:49.000+0000 | -73.97987 | 40.765709 | -74.001389 | 40.736309 | 1 |
| 2009-11-07T14:13:00.000+0000 | 14.1 | 2009-11-07T14:13:00.000+0000 | -74.010005 | 40.771582 | -74.003845 | 40.75982 | 1 |
| 2012-08-15T21:23:38.000+0000 | 6.9 | 2012-08-15T21:23:38.000+0000 | -74.002667 | 40.734013 | -73.988277 | 40.72334 | 1 |
| 2013-10-05T20:24:51.000+0000 | 16.0 | 2013-10-05T20:24:51.000+0000 | -73.794116 | 40.657058 | -73.794132 | 40.657039 | 1 |
| 2015-06-22T01:54:24.000+0000 | 6.5 | 2015-06-22T01:54:24.000+0000 | -74.00007629394531 | 40.72861099243164 | -73.98873138427734 | 40.72217178344727 | 6 |
| 2010-09-07T02:25:00.000+0000 | 3.3 | 2010-09-07T02:25:00.000+0000 | -73.982188 | 40.776687 | -73.974647 | 40.784025 | 1 |
| 2011-06-13T10:59:34.000+0000 | 6.5 | 2011-06-13T10:59:34.000+0000 | -73.976504 | 40.757149 | -73.988537 | 40.759387 | 2 |
| 2013-04-11T09:14:00.000+0000 | 5.0 | 2013-04-11T09:14:00.000+0000 | -73.99292 | 40.737055 | -74.001562 | 40.738412 | 2 |
| 2011-07-16T06:12:00.000+0000 | 6.1 | 2011-07-16T06:12:00.000+0000 | -73.999728 | 40.733533 | -73.984657 | 40.755913 | 1 |
| 2014-11-18T09:19:00.000+0000 | 57.33 | 2014-11-18T09:19:00.000+0000 | -73.77672 | 40.645412 | -73.978832 | 40.774932 | 1 |
| 2009-11-26T18:36:00.000+0000 | 5.3 | 2009-11-26T18:36:00.000+0000 | -73.97712 | 40.759838 | -73.981875 | 40.745338 | 1 |
| 2011-04-08T17:25:13.000+0000 | 10.9 | 2011-04-08T17:25:13.000+0000 | -73.992332 | 40.748792 | -73.966374 | 40.760099 | 3 |
| 2011-11-12T02:04:04.000+0000 | 4.1 | 2011-11-12T02:04:04.000+0000 | -73.992253 | 40.763919 | -73.99123 | 40.757765 | 1 |
| 2012-04-30T19:19:00.000+0000 | 11.3 | 2012-04-30T19:19:00.000+0000 | -73.969548 | 40.800192 | -73.979993 | 40.76463 | 5 |
| 2013-09-25T14:47:00.000+0000 | 5.5 | 2013-09-25T14:47:00.000+0000 | -74.003637 | 40.747477 | -73.99989 | 40.740652 | 1 |
| 2014-01-17T22:33:39.000+0000 | 10.0 | 2014-01-17T22:33:39.000+0000 | -73.984235 | 40.75501 | -73.955425 | 40.781094 | 1 |
| 2014-08-05T16:40:00.000+0000 | 4.0 | 2014-08-05T16:40:00.000+0000 | -73.954767 | 40.78389 | -73.958958 | 40.780905 | 1 |
| 2009-01-10T16:28:00.000+0000 | 2.9 | 2009-01-10T16:28:00.000+0000 | -73.977417 | 40.757653 | -73.974607 | 40.756757 | 1 |
| 2011-01-08T16:35:00.000+0000 | 6.9 | 2011-01-08T16:35:00.000+0000 | -73.966327 | 40.761268 | -73.98294 | 40.776795 | 1 |
| 2011-04-20T22:47:00.000+0000 | 8.9 | 2011-04-20T22:47:00.000+0000 | -73.98913 | 40.756668 | -73.96107 | 40.757225 | 2 |
| 2013-01-21T19:08:58.000+0000 | 4.5 | 2013-01-21T19:08:58.000+0000 | -73.990909 | 40.739949 | -73.993856 | 40.732722 | 1 |
| 2013-09-13T11:44:00.000+0000 | 4.5 | 2013-09-13T11:44:00.000+0000 | -73.965037 | 40.761717 | -73.968077 | 40.763042 | 5 |
| 2011-11-05T23:43:58.000+0000 | 12.9 | 2011-11-05T23:43:58.000+0000 | -73.966769 | 40.76412 | -73.96497 | 40.806619 | 1 |
| 2010-06-26T08:49:46.000+0000 | 5.3 | 2010-06-26T08:49:46.000+0000 | -73.977092 | 40.776832 | -73.985983 | 40.762642 | 2 |
| 2010-07-06T17:09:32.000+0000 | 6.9 | 2010-07-06T17:09:32.000+0000 | -73.988254 | 40.74895 | -73.98705 | 40.733678 | 1 |
| 2010-09-30T07:56:00.000+0000 | 16.1 | 2010-09-30T07:56:00.000+0000 | -73.986585 | 40.725585 | -73.936913 | 40.793967 | 5 |
| 2011-11-23T17:58:00.000+0000 | 26.9 | 2011-11-23T17:58:00.000+0000 | -73.874558 | 40.774082 | -73.96394 | 40.76601 | 1 |
| 2013-02-15T17:36:00.000+0000 | 6.0 | 2013-02-15T17:36:00.000+0000 | -74.002417 | 40.728325 | -73.991863 | 40.744282 | 1 |
| 2014-06-30T11:26:37.000+0000 | 6.0 | 2014-06-30T11:26:37.000+0000 | -73.995635 | 40.744387 | -74.002325 | 40.730406 | 1 |
| 2014-10-11T19:30:26.000+0000 | 14.5 | 2014-10-11T19:30:26.000+0000 | -73.985221 | 40.763296 | -73.96557 | 40.760494 | 2 |
| 2011-05-09T22:27:35.000+0000 | 3.3 | 2011-05-09T22:27:35.000+0000 | -74.004287 | 40.72194 | -73.998599 | 40.722939 | 1 |
| 2011-06-21T19:47:46.000+0000 | 9.7 | 2011-06-21T19:47:46.000+0000 | -73.997032 | 40.722398 | -73.98433 | 40.754394 | 1 |
| 2012-07-29T15:27:45.000+0000 | 4.5 | 2012-07-29T15:27:45.000+0000 | -73.977092 | 40.75848 | -73.968008 | 40.762297 | 2 |
| 2012-11-12T17:59:46.000+0000 | 15.5 | 2012-11-12T17:59:46.000+0000 | -73.964517 | 40.767404 | -74.003496 | 40.741095 | 1 |
| 2014-07-09T14:51:00.000+0000 | 15.5 | 2014-07-09T14:51:00.000+0000 | -73.975655 | 40.792012 | -73.951775 | 40.769527 | 1 |
| 2015-03-14T22:19:01.000+0000 | 14.0 | 2015-03-14T22:19:01.000+0000 | -73.94877624511719 | 40.782493591308594 | -73.9822006225586 | 40.75661087036133 | 2 |
| 2009-09-19T10:34:41.000+0000 | 66.3 | 2009-09-19T10:34:41.000+0000 | -74.438233 | 40.99326 | -74.185996 | 40.693874 | 2 |
| 2010-10-07T21:09:35.000+0000 | 14.1 | 2010-10-07T21:09:35.000+0000 | -74.003545 | 40.707399 | -73.981312 | 40.750071 | 1 |
| 2010-11-04T17:49:53.000+0000 | 18.5 | 2010-11-04T17:49:53.000+0000 | -73.987118 | 40.73596 | -73.95641 | 40.780902 | 2 |
| 2011-04-15T18:55:48.000+0000 | 12.1 | 2011-04-15T18:55:48.000+0000 | -73.983423 | 40.7613 | -74.009493 | 40.74775 | 1 |
| 2012-03-02T13:13:00.000+0000 | 11.7 | 2012-03-02T13:13:00.000+0000 | -73.96669 | 40.765072 | -73.978243 | 40.791957 | 1 |
| 2012-11-24T09:59:00.000+0000 | 3.5 | 2012-11-24T09:59:00.000+0000 | -73.970932 | 40.788492 | -73.973835 | 40.79204 | 1 |
| 2014-09-05T00:48:01.000+0000 | 10.5 | 2014-09-05T00:48:01.000+0000 | -74.00344 | 40.743554 | -73.974042 | 40.750274 | 3 |
| 2014-04-07T07:41:50.000+0000 | 20.5 | 2014-04-07T07:41:50.000+0000 | -74.016064 | 40.711575 | -73.983339 | 40.760979 | 1 |
| 2009-08-25T01:50:21.000+0000 | 2.5 | 2009-08-25T01:50:21.000+0000 | -73.98641 | 40.76335 | -73.98641 | 40.76335 | 1 |
| 2013-04-17T18:27:15.000+0000 | 21.0 | 2013-04-17T18:27:15.000+0000 | -73.977208 | 40.733786 | -73.978238 | 40.686617 | 1 |
| 2014-09-29T14:34:00.000+0000 | 9.5 | 2014-09-29T14:34:00.000+0000 | -73.969977 | 40.765472 | -73.95734 | 40.783072 | 6 |
| 2010-08-18T03:46:00.000+0000 | 13.3 | 2010-08-18T03:46:00.000+0000 | 0.0 | 0.0 | 0.0 | 0.0 | 5 |
| 2010-12-24T22:34:00.000+0000 | 8.9 | 2010-12-24T22:34:00.000+0000 | -73.978465 | 40.758843 | -74.004952 | 40.737495 | 2 |
| 2011-06-30T08:08:14.000+0000 | 10.5 | 2011-06-30T08:08:14.000+0000 | -73.959055 | 40.814999 | -73.957878 | 40.778607 | 1 |
| 2013-03-11T09:42:26.000+0000 | 4.5 | 2013-03-11T09:42:26.000+0000 | -74.008646 | 40.735048 | -74.006229 | 40.725949 | 1 |
| 2014-10-07T15:02:06.000+0000 | 24.5 | 2014-10-07T15:02:06.000+0000 | -73.979269 | 40.761886 | -74.002076 | 40.724702 | 1 |
| 2015-04-05T00:54:56.000+0000 | 27.0 | 2015-04-05T00:54:56.000+0000 | -73.98755645751953 | 40.733673095703125 | -73.95068359375 | 40.823066711425774 | 1 |
| 2011-07-15T11:49:00.000+0000 | 8.5 | 2011-07-15T11:49:00.000+0000 | -73.978135 | 40.73074 | -73.977188 | 40.752542 | 1 |
| 2014-06-25T23:08:56.000+0000 | 9.0 | 2014-06-25T23:08:56.000+0000 | -73.977865 | 40.784274 | -73.962362 | 40.767125 | 2 |
| 2014-10-30T23:19:00.000+0000 | 9.5 | 2014-10-30T23:19:00.000+0000 | -73.952838 | 40.786623 | -73.957865 | 40.765458 | 1 |
| 2010-06-15T15:07:00.000+0000 | 6.5 | 2010-06-15T15:07:00.000+0000 | -73.958882 | 40.709567 | -73.98527 | 40.718643 | 1 |
| 2012-01-08T02:10:00.000+0000 | 19.7 | 2012-01-08T02:10:00.000+0000 | -73.987122 | 40.73655 | -73.902657 | 40.769043 | 2 |
| 2012-08-30T18:17:13.000+0000 | 30.9 | 2012-08-30T18:17:13.000+0000 | -73.978438 | 40.737 | -73.864842 | 40.770393 | 2 |
| 2013-07-29T22:19:22.000+0000 | 8.5 | 2013-07-29T22:19:22.000+0000 | -73.983246 | 40.750915 | -74.006032 | 40.735215 | 1 |
| 2009-09-27T06:48:00.000+0000 | 6.5 | 2009-09-27T06:48:00.000+0000 | -73.994017 | 40.761638 | -73.985845 | 40.744387 | 1 |
| 2010-05-07T20:05:00.000+0000 | 14.9 | 2010-05-07T20:05:00.000+0000 | -73.968212 | 40.762212 | -73.919958 | 40.755087 | 2 |
| 2012-03-21T05:27:08.000+0000 | 16.1 | 2012-03-21T05:27:08.000+0000 | -73.970357 | 40.789113 | -74.011695 | 40.707435 | 1 |
| 2013-04-12T19:57:22.000+0000 | 5.5 | 2013-04-12T19:57:22.000+0000 | -73.789203 | 40.655194 | -73.996509 | 40.737216 | 1 |
| 2013-09-19T23:58:08.000+0000 | 20.5 | 2013-09-19T23:58:08.000+0000 | -73.989813 | 40.747356 | -73.927147 | 40.762732 | 1 |
| 2012-02-27T07:24:20.000+0000 | 6.5 | 2012-02-27T07:24:20.000+0000 | -73.983397 | 40.738183 | -73.971395 | 40.758023 | 0 |
| 2013-09-13T07:03:17.000+0000 | 5.0 | 2013-09-13T07:03:17.000+0000 | -73.977487 | 40.763365 | -73.983377 | 40.7547 | 1 |
| 2014-01-04T08:43:24.000+0000 | 5.0 | 2014-01-04T08:43:24.000+0000 | -73.98573 | 40.7681 | -73.981444 | 40.778745 | 1 |
| 2014-04-21T13:33:03.000+0000 | 16.5 | 2014-04-21T13:33:03.000+0000 | -74.006602 | 40.744235 | -73.979251 | 40.751236 | 1 |
| 2015-02-28T07:50:05.000+0000 | 16.0 | 2015-02-28T07:50:05.000+0000 | -73.95174407958984 | 40.77205657958984 | -73.94265747070312 | 40.74713516235352 | 5 |
| 2010-08-08T13:12:13.000+0000 | 10.9 | 2010-08-08T13:12:13.000+0000 | -73.977385 | 40.758089 | -74.001467 | 40.720059 | 4 |
| 2012-02-21T12:13:11.000+0000 | 16.5 | 2012-02-21T12:13:11.000+0000 | -74.010894 | 40.714426 | -73.98337 | 40.756248 | 1 |
| 2013-07-27T23:20:00.000+0000 | 20.5 | 2013-07-27T23:20:00.000+0000 | -73.98441 | 40.716667 | -73.922238 | 40.767287 | 6 |
| 2011-12-02T19:50:13.000+0000 | 7.3 | 2011-12-02T19:50:13.000+0000 | -73.9594 | 40.7703 | -73.9663 | 40.7606 | 1 |
| 2015-06-27T22:06:57.000+0000 | 9.0 | 2015-06-27T22:06:57.000+0000 | -73.99384307861328 | 40.714691162109375 | -73.9970703125 | 40.71773147583008 | 3 |
| 2014-03-14T00:05:00.000+0000 | 15.5 | 2014-03-14T00:05:00.000+0000 | -73.997507 | 40.721777 | -74.000732 | 40.676375 | 1 |
| 2014-08-19T16:52:48.000+0000 | 5.0 | 2014-08-19T16:52:48.000+0000 | -73.995087 | 40.760146 | -73.982215 | 40.763185 | 1 |
| 2014-09-30T16:13:00.000+0000 | 57.33 | 2014-09-30T16:13:00.000+0000 | -74.00775 | 40.741277 | -73.790292 | 40.64676 | 2 |
| 2009-07-07T00:19:38.000+0000 | 10.5 | 2009-07-07T00:19:38.000+0000 | -73.979982 | 40.762695 | -73.962557 | 40.804685 | 1 |
| 2013-08-02T20:12:13.000+0000 | 9.5 | 2013-08-02T20:12:13.000+0000 | -74.008117 | 40.748635 | -74.01037 | 40.718968 | 3 |
| 2009-03-30T10:56:00.000+0000 | 4.1 | 2009-03-30T10:56:00.000+0000 | -73.99093 | 40.765603 | -73.982563 | 40.77027 | 1 |
| 2011-12-01T15:38:24.000+0000 | 12.1 | 2011-12-01T15:38:24.000+0000 | -73.959546 | 40.767462 | -73.993107 | 40.75767 | 2 |
| 2013-11-24T20:54:00.000+0000 | 7.0 | 2013-11-24T20:54:00.000+0000 | -73.971542 | 40.750487 | -73.988967 | 40.72994 | 1 |
| 2010-04-15T21:12:39.000+0000 | 4.9 | 2010-04-15T21:12:39.000+0000 | -73.978556 | 40.724624 | -73.988157 | 40.722875 | 1 |
| 2010-12-08T08:14:00.000+0000 | 4.9 | 2010-12-08T08:14:00.000+0000 | -73.979307 | 40.752832 | -73.978403 | 40.758903 | 1 |
| 2013-05-15T16:56:45.000+0000 | 11.0 | 2013-05-15T16:56:45.000+0000 | -73.979658 | 40.758764 | -73.95657 | 40.768108 | 1 |
| 2013-07-11T21:10:00.000+0000 | 5.5 | 2013-07-11T21:10:00.000+0000 | -73.978007 | 40.74581 | -73.98425 | 40.73341 | 2 |
| 2013-07-31T09:31:00.000+0000 | 7.0 | 2013-07-31T09:31:00.000+0000 | -73.9894 | 40.756855 | -73.992802 | 40.768222 | 1 |
| 2010-03-22T14:59:45.000+0000 | 3.7 | 2010-03-22T14:59:45.000+0000 | -73.961353 | 40.765069 | -73.96052 | 40.769931 | 1 |
| 2011-12-21T21:40:17.000+0000 | 6.5 | 2011-12-21T21:40:17.000+0000 | -74.0098 | 40.7205 | -74.009 | 40.7408 | 4 |
| 2012-05-21T11:37:42.000+0000 | 15.3 | 2012-05-21T11:37:42.000+0000 | -73.99217 | 40.76432 | -73.966214 | 40.762562 | 1 |
| 2014-08-21T12:40:24.000+0000 | 38.33 | 2014-08-21T12:40:24.000+0000 | -73.977151 | 40.776857 | -73.861551 | 40.768274 | 1 |
| 2012-10-10T12:40:54.000+0000 | 6.5 | 2012-10-10T12:40:54.000+0000 | -73.980759 | 40.680705 | -73.989813 | 40.690149 | 1 |
| 2013-01-04T17:06:26.000+0000 | 17.0 | 2013-01-04T17:06:26.000+0000 | -74.001311 | 40.75699 | -73.948801 | 40.797008 | 1 |
| 2009-11-12T08:33:00.000+0000 | 10.1 | 2009-11-12T08:33:00.000+0000 | -74.00096 | 40.731835 | -73.974342 | 40.751058 | 1 |
| 2011-02-16T12:02:00.000+0000 | 18.9 | 2011-02-16T12:02:00.000+0000 | -74.010163 | 40.708902 | -73.987847 | 40.749225 | 5 |
| 2012-07-09T07:54:34.000+0000 | 38.5 | 2012-07-09T07:54:34.000+0000 | -73.862568 | 40.769065 | -74.008287 | 40.705275 | 1 |
| 2013-03-11T09:31:00.000+0000 | 8.5 | 2013-03-11T09:31:00.000+0000 | -73.983518 | 40.748147 | -73.98987 | 40.725757 | 1 |
| 2014-11-06T23:10:00.000+0000 | 7.0 | 2014-11-06T23:10:00.000+0000 | -73.97173 | 40.75715 | -73.98541 | 40.747 | 1 |
| 2014-12-13T18:37:00.000+0000 | 8.5 | 2014-12-13T18:37:00.000+0000 | -73.983267 | 40.741622 | -74.001337 | 40.731072 | 1 |
| 2009-01-27T11:55:16.000+0000 | 7.7 | 2009-01-27T11:55:16.000+0000 | -73.991197 | 40.751257 | -73.975178 | 40.750687 | 1 |
| 2010-12-03T22:08:47.000+0000 | 5.7 | 2010-12-03T22:08:47.000+0000 | -74.0029 | 40.760422 | -73.988729 | 40.761702 | 2 |
| 2013-12-14T02:04:00.000+0000 | 4.5 | 2013-12-14T02:04:00.000+0000 | -73.98384 | 40.72957 | -73.989737 | 40.725755 | 2 |
| 2012-03-12T06:57:20.000+0000 | 7.7 | 2012-03-12T06:57:20.000+0000 | -73.957788 | 40.761912 | -73.976757 | 40.75214 | 1 |
| 2013-01-17T23:42:16.000+0000 | 45.0 | 2013-01-17T23:42:16.000+0000 | -73.999081 | 40.754489 | -73.863401 | 40.667613 | 1 |
| 2013-05-25T02:42:55.000+0000 | 8.0 | 2013-05-25T02:42:55.000+0000 | -73.99563 | 40.720941 | -73.961689 | 40.709743 | 2 |
| 2009-08-26T15:59:53.000+0000 | 4.5 | 2009-08-26T15:59:53.000+0000 | -73.991315 | 40.751183 | -74.003637 | 40.753584 | 1 |
| 2012-01-18T13:52:00.000+0000 | 5.7 | 2012-01-18T13:52:00.000+0000 | -73.978617 | 40.748468 | -73.975885 | 40.75505 | 2 |
| 2010-04-17T23:43:40.000+0000 | 9.7 | 2010-04-17T23:43:40.000+0000 | -74.002097 | 40.734732 | -73.972335 | 40.756477 | 2 |
| 2010-10-31T01:12:41.000+0000 | 10.9 | 2010-10-31T01:12:41.000+0000 | -74.005771 | 40.736004 | -73.989396 | 40.718013 | 1 |
| 2010-11-10T16:44:00.000+0000 | 5.7 | 2010-11-10T16:44:00.000+0000 | -74.00722 | 40.727557 | -73.994682 | 40.750242 | 1 |
| 2014-01-18T23:03:00.000+0000 | 4.0 | 2014-01-18T23:03:00.000+0000 | -74.005432 | 40.736957 | -73.99864 | 40.744997 | 1 |
| 2009-08-20T13:25:00.000+0000 | 4.9 | 2009-08-20T13:25:00.000+0000 | -73.989897 | 40.750725 | -73.988952 | 40.755345 | 3 |
| 2009-10-01T06:43:42.000+0000 | 31.2 | 2009-10-01T06:43:42.000+0000 | -73.975427 | 40.757116 | -73.86509 | 40.770561 | 1 |
| 2009-10-06T18:24:14.000+0000 | 13.3 | 2009-10-06T18:24:14.000+0000 | -73.987699 | 40.757444 | -73.996644 | 40.719542 | 1 |
| 2010-02-13T01:52:11.000+0000 | 11.7 | 2010-02-13T01:52:11.000+0000 | 0.0 | 0.0 | 0.0 | 0.0 | 1 |
| 2011-05-09T13:06:40.000+0000 | 8.9 | 2011-05-09T13:06:40.000+0000 | -74.008557 | 40.72074 | -73.981338 | 40.728984 | 1 |
| 2012-07-22T16:36:14.000+0000 | 4.5 | 2012-07-22T16:36:14.000+0000 | -73.926383 | 40.808057 | -73.93513 | 40.814371 | 1 |
| 2012-09-08T05:19:00.000+0000 | 20.0 | 2012-09-08T05:19:00.000+0000 | -73.996222 | 40.738397 | -73.945933 | 40.792682 | 2 |
| 2015-03-01T02:08:36.000+0000 | 7.0 | 2015-03-01T02:08:36.000+0000 | -73.9864273071289 | 40.72238540649414 | -73.99151611328125 | 40.735233306884766 | 1 |
| 2009-03-18T19:47:00.000+0000 | 4.5 | 2009-03-18T19:47:00.000+0000 | -73.995892 | 40.74389 | -74.004377 | 40.734933 | 5 |
| 2012-09-10T14:39:00.000+0000 | 16.5 | 2012-09-10T14:39:00.000+0000 | -73.988522 | 40.737147 | -73.986408 | 40.776832 | 1 |
| 2011-11-01T09:52:40.000+0000 | 12.9 | 2011-11-01T09:52:40.000+0000 | -73.981384 | 40.780106 | -73.971353 | 40.758763 | 1 |
| 2012-04-20T15:36:33.000+0000 | 34.1 | 2012-04-20T15:36:33.000+0000 | -73.873254 | 40.773999 | -73.983536 | 40.762902 | 1 |
| 2014-08-11T19:37:00.000+0000 | 57.33 | 2014-08-11T19:37:00.000+0000 | -73.776477 | 40.64629 | -73.776477 | 40.64629 | 2 |
| 2010-06-15T01:06:00.000+0000 | 8.9 | 2010-06-15T01:06:00.000+0000 | -73.788498 | 40.65458 | -73.752772 | 40.6617 | 1 |
| 2014-02-07T22:43:37.000+0000 | 13.0 | 2014-02-07T22:43:37.000+0000 | -73.985717 | 40.767798 | -73.959253 | 40.80919 | 1 |
| 2012-03-29T18:39:00.000+0000 | 9.7 | 2012-03-29T18:39:00.000+0000 | -73.98011 | 40.75182 | -73.950907 | 40.775948 | 1 |
| 2013-01-16T19:55:00.000+0000 | 11.0 | 2013-01-16T19:55:00.000+0000 | -73.987055 | 40.744762 | -74.007825 | 40.716325 | 3 |
| 2014-12-23T20:50:00.000+0000 | 5.5 | 2014-12-23T20:50:00.000+0000 | -73.967705 | 40.75989 | -73.95623 | 40.768088 | 1 |
| 2011-05-05T20:30:00.000+0000 | 4.9 | 2011-05-05T20:30:00.000+0000 | -73.975245 | 40.763207 | -73.963428 | 40.77076 | 1 |
| 2009-08-10T18:12:00.000+0000 | 9.3 | 2009-08-10T18:12:00.000+0000 | -73.966555 | 40.769955 | -73.97153 | 40.74431 | 3 |
| 2010-04-16T20:35:21.000+0000 | 8.5 | 2010-04-16T20:35:21.000+0000 | -73.944602 | 40.815676 | -73.917888 | 40.806313 | 1 |
| 2013-01-31T22:14:00.000+0000 | 4.5 | 2013-01-31T22:14:00.000+0000 | -73.985247 | 40.727532 | -73.979572 | 40.735312 | 1 |
| 2011-10-10T07:32:00.000+0000 | 11.3 | 2011-10-10T07:32:00.000+0000 | -73.974097 | 40.759455 | -74.009692 | 40.722595 | 1 |
| 2012-03-13T21:24:00.000+0000 | 13.7 | 2012-03-13T21:24:00.000+0000 | -73.977078 | 40.750085 | -74.01442 | 40.716932 | 1 |
| 2012-01-06T06:51:46.000+0000 | 6.9 | 2012-01-06T06:51:46.000+0000 | -73.990062 | 40.756634 | -73.971327 | 40.758445 | 1 |
| 2012-07-31T07:20:31.000+0000 | 8.1 | 2012-07-31T07:20:31.000+0000 | -73.918489 | 40.754256 | -73.969701 | 40.748919 | 1 |
| 2013-01-02T21:00:00.000+0000 | 11.0 | 2013-01-02T21:00:00.000+0000 | -73.97427 | 40.756035 | -73.96899 | 40.785887 | 1 |
| 2011-07-06T08:56:49.000+0000 | 6.9 | 2011-07-06T08:56:49.000+0000 | -73.967169 | 40.756601 | -73.980451 | 40.756584 | 2 |
| 2013-08-27T18:55:00.000+0000 | 4.5 | 2013-08-27T18:55:00.000+0000 | -73.958917 | 40.77215 | -73.956942 | 40.780182 | 2 |
| 2010-04-20T19:31:00.000+0000 | 6.1 | 2010-04-20T19:31:00.000+0000 | -73.983305 | 40.748403 | -73.991115 | 40.765688 | 1 |
| 2011-01-22T23:24:00.000+0000 | 7.7 | 2011-01-22T23:24:00.000+0000 | -73.969023 | 40.785718 | -73.992152 | 40.769105 | 5 |
| 2011-08-15T20:36:40.000+0000 | 12.9 | 2011-08-15T20:36:40.000+0000 | -73.952351 | 40.789832 | -73.972333 | 40.745006 | 1 |
| 2012-07-05T12:23:00.000+0000 | 8.1 | 2012-07-05T12:23:00.000+0000 | -73.993822 | 40.732997 | -73.9847 | 40.742632 | 1 |
| 2009-10-16T22:54:39.000+0000 | 35.07 | 2009-10-16T22:54:39.000+0000 | -73.994618 | 40.739409 | -73.936439 | 40.629948 | 1 |
| 2010-08-30T19:58:00.000+0000 | 12.1 | 2010-08-30T19:58:00.000+0000 | -73.997868 | 40.713628 | -73.989445 | 40.756853 | 4 |
| 2011-08-04T18:39:50.000+0000 | 9.3 | 2011-08-04T18:39:50.000+0000 | -73.981206 | 40.757788 | -73.994317 | 40.754246 | 1 |
| 2014-01-09T21:55:00.000+0000 | 21.5 | 2014-01-09T21:55:00.000+0000 | -74.001562 | 40.741032 | -73.95868 | 40.719377 | 1 |
| 2011-09-18T14:41:56.000+0000 | 6.9 | 2011-09-18T14:41:56.000+0000 | -73.992014 | 40.764244 | -73.981024 | 40.781859 | 2 |
| 2014-01-30T21:38:00.000+0000 | 10.0 | 2014-01-30T21:38:00.000+0000 | -73.982053 | 40.77331 | -73.955055 | 40.781017 | 1 |
| 2014-09-03T15:29:00.000+0000 | 8.5 | 2014-09-03T15:29:00.000+0000 | -73.999112 | 40.72521 | -74.007372 | 40.740927 | 1 |
| 2015-02-22T12:46:09.000+0000 | 26.5 | 2015-02-22T12:46:09.000+0000 | -74.01361846923827 | 40.71653366088867 | -73.94696807861328 | 40.772075653076165 | 1 |
| 2010-08-08T16:47:00.000+0000 | 4.5 | 2010-08-08T16:47:00.000+0000 | -73.975867 | 40.760282 | -73.980965 | 40.753368 | 5 |
| 2011-09-10T23:51:43.000+0000 | 6.9 | 2011-09-10T23:51:43.000+0000 | -73.983855 | 40.744069 | -74.005639 | 40.740089 | 3 |
| 2010-03-12T13:30:00.000+0000 | 6.5 | 2010-03-12T13:30:00.000+0000 | -73.973112 | 40.761903 | -73.952725 | 40.766447 | 1 |
| 2010-10-26T15:25:00.000+0000 | 4.9 | 2010-10-26T15:25:00.000+0000 | -73.947062 | 40.784043 | -73.951198 | 40.772092 | 1 |
| 2011-04-24T21:06:14.000+0000 | 13.3 | 2011-04-24T21:06:14.000+0000 | -74.002185 | 40.719517 | -73.974876 | 40.756321 | 4 |
| 2011-06-20T14:52:22.000+0000 | 18.5 | 2011-06-20T14:52:22.000+0000 | -73.997892 | 40.724297 | -73.977578 | 40.786941 | 1 |
| 2012-11-18T15:58:00.000+0000 | 8.0 | 2012-11-18T15:58:00.000+0000 | -73.972767 | 40.793497 | -73.959495 | 40.780095 | 1 |
| 2013-10-15T07:48:17.000+0000 | 5.5 | 2013-10-15T07:48:17.000+0000 | -73.989863 | 40.734053 | -73.979853 | 40.744464 | 1 |
| 2012-04-19T19:11:35.000+0000 | 28.1 | 2012-04-19T19:11:35.000+0000 | -73.863763 | 40.769938 | -74.00032 | 40.71624 | 1 |
| 2012-04-30T14:56:33.000+0000 | 6.5 | 2012-04-30T14:56:33.000+0000 | -73.976558 | 40.759555 | -73.983238 | 40.766241 | 1 |
| 2009-10-15T19:30:00.000+0000 | 12.9 | 2009-10-15T19:30:00.000+0000 | -73.98362 | 40.767035 | -73.985725 | 40.72776 | 1 |
| 2010-10-20T18:19:41.000+0000 | 4.1 | 2010-10-20T18:19:41.000+0000 | -73.96954 | 40.760876 | -73.975164 | 40.752973 | 1 |
| 2011-02-07T08:39:21.000+0000 | 10.5 | 2011-02-07T08:39:21.000+0000 | -73.964999 | 40.806719 | -73.958495 | 40.784222 | 1 |
| 2011-06-14T23:51:00.000+0000 | 12.1 | 2011-06-14T23:51:00.000+0000 | -73.983403 | 40.726223 | -73.999103 | 40.761795 | 1 |
| 2011-06-22T23:45:19.000+0000 | 13.7 | 2011-06-22T23:45:19.000+0000 | -73.981527 | 40.724907 | -73.949038 | 40.72631 | 1 |
| 2012-06-06T15:05:32.000+0000 | 16.1 | 2012-06-06T15:05:32.000+0000 | -73.954942 | 40.789074 | -73.984561 | 40.748882 | 1 |
| 2014-08-25T20:37:22.000+0000 | 3.0 | 2014-08-25T20:37:22.000+0000 | -74.007472 | 40.74088 | -74.008959 | 40.738234 | 1 |
| 2010-12-15T22:18:27.000+0000 | 8.5 | 2010-12-15T22:18:27.000+0000 | -73.985287 | 40.773551 | -73.964319 | 40.809258 | 1 |
| 2015-04-01T22:29:31.000+0000 | 13.5 | 2015-04-01T22:29:31.000+0000 | -73.96198272705078 | 40.7636833190918 | -73.99638366699219 | 40.73807907104492 | 1 |
| 2011-10-17T18:58:23.000+0000 | 4.9 | 2011-10-17T18:58:23.000+0000 | -73.992414 | 40.74972 | -73.995103 | 40.750485 | 1 |
| 2012-03-15T20:31:31.000+0000 | 4.9 | 2012-03-15T20:31:31.000+0000 | -73.97164 | 40.766172 | -73.960692 | 40.76807 | 1 |
| 2014-11-24T02:46:00.000+0000 | 27.0 | 2014-11-24T02:46:00.000+0000 | -74.008827 | 40.710565 | -73.92766 | 40.759892 | 1 |
| 2014-03-12T13:13:14.000+0000 | 6.0 | 2014-03-12T13:13:14.000+0000 | -73.977032 | 40.750545 | -73.990488 | 40.737205 | 1 |
| 2015-01-10T21:18:25.000+0000 | 5.5 | 2015-01-10T21:18:25.000+0000 | -73.9844970703125 | 40.728797912597656 | -73.98408508300781 | 40.72538375854492 | 1 |
| 2011-09-25T14:09:00.000+0000 | 24.9 | 2011-09-25T14:09:00.000+0000 | -73.994673 | 40.750317 | -73.945843 | 40.835722 | 2 |
| 2015-03-22T14:23:12.000+0000 | 22.5 | 2015-03-22T14:23:12.000+0000 | -73.96234130859375 | 40.77907180786133 | -74.00598907470702 | 40.70943832397461 | 4 |
| 2013-01-15T16:02:57.000+0000 | 15.0 | 2013-01-15T16:02:57.000+0000 | -73.983491 | 40.734315 | -73.956837 | 40.7042 | 1 |
| 2013-11-20T16:58:00.000+0000 | 13.0 | 2013-11-20T16:58:00.000+0000 | -73.988382 | 40.764137 | -73.99152 | 40.7502 | 1 |
| 2009-02-16T07:40:14.000+0000 | 14.5 | 2009-02-16T07:40:14.000+0000 | -73.948872 | 40.807601 | -73.937218 | 40.767366 | 1 |
| 2009-02-27T17:39:00.000+0000 | 8.1 | 2009-02-27T17:39:00.000+0000 | -73.992877 | 40.742668 | -73.983468 | 40.74748 | 1 |
| 2009-11-05T00:57:13.000+0000 | 15.7 | 2009-11-05T00:57:13.000+0000 | -74.004128 | 40.733121 | -73.966117 | 40.677112 | 1 |
| 2010-12-11T01:55:00.000+0000 | 10.5 | 2010-12-11T01:55:00.000+0000 | -73.997677 | 40.722583 | -73.992827 | 40.679183 | 2 |
| 2012-02-12T15:18:00.000+0000 | 45.0 | 2012-02-12T15:18:00.000+0000 | -73.969852 | 40.750962 | -73.781802 | 40.648527 | 1 |
| 2013-12-08T23:39:00.000+0000 | 3.0 | 2013-12-08T23:39:00.000+0000 | 0.0 | 0.0 | 0.0 | 0.0 | 5 |
| 2009-12-29T09:44:01.000+0000 | 4.1 | 2009-12-29T09:44:01.000+0000 | -73.973141 | 40.785315 | -73.980153 | 40.775721 | 1 |
| 2010-04-27T20:20:00.000+0000 | 23.7 | 2010-04-27T20:20:00.000+0000 | -74.005322 | 40.650103 | -73.859852 | 40.711942 | 1 |
| 2010-04-27T20:20:00.000+0000 | 9.3 | 2010-04-27T20:20:00.000+0000 | -73.97785 | 40.729675 | -74.005877 | 40.725813 | 1 |
| 2012-09-23T02:57:00.000+0000 | 24.5 | 2012-09-23T02:57:00.000+0000 | -73.995145 | 40.749812 | -73.940478 | 40.718662 | 3 |
| 2009-11-20T09:09:00.000+0000 | 7.3 | 2009-11-20T09:09:00.000+0000 | -73.958437 | 40.77291 | -73.974257 | 40.755255 | 1 |
| 2009-12-16T22:00:00.000+0000 | 10.1 | 2009-12-16T22:00:00.000+0000 | -73.969813 | 40.763205 | -73.992668 | 40.721372 | 2 |
| 2010-03-23T14:52:16.000+0000 | 3.7 | 2010-03-23T14:52:16.000+0000 | -73.995863 | 40.744098 | -73.990998 | 40.741071 | 1 |
| 2010-05-08T16:17:04.000+0000 | 9.7 | 2010-05-08T16:17:04.000+0000 | -73.990431 | 40.757773 | -73.972639 | 40.763474 | 1 |
| 2010-10-22T02:24:53.000+0000 | 6.1 | 2010-10-22T02:24:53.000+0000 | -73.984433 | 40.771084 | -73.984433 | 40.771084 | 1 |
| 2011-05-07T15:12:32.000+0000 | 49.8 | 2011-05-07T15:12:32.000+0000 | -73.782235 | 40.644691 | -73.973344 | 40.738062 | 2 |
| 2011-10-14T12:20:00.000+0000 | 4.9 | 2011-10-14T12:20:00.000+0000 | -73.952797 | 40.780497 | -73.955042 | 40.788527 | 5 |
| 2011-11-08T07:14:00.000+0000 | 7.7 | 2011-11-08T07:14:00.000+0000 | -73.98729 | 40.739077 | -74.008045 | 40.712155 | 1 |
| 2013-07-19T18:55:00.000+0000 | 31.83 | 2013-07-19T18:55:00.000+0000 | -73.865875 | 40.77044 | -73.979228 | 40.749225 | 1 |
| 2014-05-17T13:12:55.000+0000 | 5.0 | 2014-05-17T13:12:55.000+0000 | -73.981422 | 40.762434 | -73.983398 | 40.766286 | 2 |
| 2010-11-24T12:46:52.000+0000 | 4.5 | 2010-11-24T12:46:52.000+0000 | -73.962681 | 40.775646 | -73.957434 | 40.777766 | 1 |
| 2011-03-30T12:22:32.000+0000 | 6.9 | 2011-03-30T12:22:32.000+0000 | -73.966692 | 40.789004 | -73.959358 | 40.809018 | 1 |
| 2014-02-16T09:05:34.000+0000 | 12.5 | 2014-02-16T09:05:34.000+0000 | -73.996905 | 40.756151 | -73.954566 | 40.779943 | 1 |
| 2014-12-04T15:23:00.000+0000 | 13.5 | 2014-12-04T15:23:00.000+0000 | -73.982325 | 40.772905 | -73.965297 | 40.75908 | 6 |
| 2013-04-01T12:44:00.000+0000 | 9.5 | 2013-04-01T12:44:00.000+0000 | -73.956678 | 40.775412 | -73.977282 | 40.757577 | 1 |
| 2012-02-23T06:21:00.000+0000 | 6.1 | 2012-02-23T06:21:00.000+0000 | -73.989675 | 40.756102 | -73.970548 | 40.763163 | 1 |
| 2013-10-10T05:53:00.000+0000 | 4.5 | 2013-10-10T05:53:00.000+0000 | -73.968897 | 40.798707 | -73.966733 | 40.793995 | 1 |
| 2009-11-26T03:52:00.000+0000 | 6.5 | 2009-11-26T03:52:00.000+0000 | -73.984258 | 40.76014 | -73.99738 | 40.749263 | 1 |
| 2010-04-01T10:07:00.000+0000 | 7.3 | 2010-04-01T10:07:00.000+0000 | -73.963465 | 40.774312 | -73.9834 | 40.766893 | 1 |
| 2010-05-22T19:26:00.000+0000 | 7.7 | 2010-05-22T19:26:00.000+0000 | -73.969715 | 40.75779 | -73.99134 | 40.750123 | 1 |
| 2010-09-26T01:55:00.000+0000 | 7.7 | 2010-09-26T01:55:00.000+0000 | -73.9957 | 40.764427 | -73.992148 | 40.744787 | 2 |
| 2010-09-29T00:57:00.000+0000 | 8.9 | 2010-09-29T00:57:00.000+0000 | -73.991738 | 40.744403 | -73.959888 | 40.769403 | 2 |
| 2012-03-20T17:34:00.000+0000 | 10.5 | 2012-03-20T17:34:00.000+0000 | -73.978193 | 40.751915 | -74.004858 | 40.751853 | 1 |
| 2012-12-23T03:45:48.000+0000 | 6.0 | 2012-12-23T03:45:48.000+0000 | -73.956829 | 40.72098 | -73.957186 | 40.732846 | 1 |
| 2013-06-12T17:04:53.000+0000 | 5.0 | 2013-06-12T17:04:53.000+0000 | -73.974776 | 40.771861 | -73.980998 | 40.770901 | 1 |
| 2013-06-27T10:52:00.000+0000 | 8.0 | 2013-06-27T10:52:00.000+0000 | -73.962843 | 40.76655 | -73.947115 | 40.771767 | 1 |
| 2011-08-25T07:35:23.000+0000 | 13.3 | 2011-08-25T07:35:23.000+0000 | -73.947809 | 40.782872 | -73.988676 | 40.741282 | 1 |
| 2011-12-08T00:13:47.000+0000 | 2.9 | 2011-12-08T00:13:47.000+0000 | -73.979882 | 40.758655 | -73.977834 | 40.762103 | 1 |
| 2009-04-25T13:08:00.000+0000 | 25.450000000000003 | 2009-04-25T13:08:00.000+0000 | -73.99055 | 40.745908 | -73.885363 | 40.771893 | 1 |
| 2012-11-28T21:33:33.000+0000 | 4.5 | 2012-11-28T21:33:33.000+0000 | -73.966639 | 40.764331 | -73.959307 | 40.767477 | 1 |
| 2013-06-09T23:15:06.000+0000 | 9.0 | 2013-06-09T23:15:06.000+0000 | -74.002078 | 40.73996 | -73.979133 | 40.749912 | 2 |
| 2010-07-21T16:39:00.000+0000 | 4.1 | 2010-07-21T16:39:00.000+0000 | -73.954595 | 40.778175 | -73.952698 | 40.785715 | 1 |
| 2012-03-16T07:52:00.000+0000 | 5.3 | 2012-03-16T07:52:00.000+0000 | -73.960797 | 40.818232 | -73.953255 | 40.810163 | 1 |
| 2015-05-02T23:49:41.000+0000 | 5.5 | 2015-05-02T23:49:41.000+0000 | -73.98070526123048 | 40.77486038208008 | -73.9918441772461 | 40.763946533203125 | 1 |
| 2012-11-28T08:30:00.000+0000 | 18.0 | 2012-11-28T08:30:00.000+0000 | -74.006052 | 40.748617 | -73.962892 | 40.8042 | 1 |
| 2013-09-30T13:11:00.000+0000 | 4.5 | 2013-09-30T13:11:00.000+0000 | -73.947355 | 40.764565 | -73.952475 | 40.758697 | 1 |
| 2014-10-22T08:12:00.000+0000 | 6.0 | 2014-10-22T08:12:00.000+0000 | -73.99686 | 40.72311 | -74.00537 | 40.73235 | 1 |
| 2010-09-09T14:22:00.000+0000 | 8.1 | 2010-09-09T14:22:00.000+0000 | -73.96226 | 40.759743 | -73.953148 | 40.770363 | 2 |
| 2013-02-14T19:35:44.000+0000 | 9.5 | 2013-02-14T19:35:44.000+0000 | -74.005739 | 40.740252 | -74.011023 | 40.716267 | 1 |
| 2014-07-19T04:42:00.000+0000 | 5.5 | 2014-07-19T04:42:00.000+0000 | -73.990532 | 40.719085 | -73.990532 | 40.719085 | 1 |
| 2014-10-15T09:43:35.000+0000 | 23.0 | 2014-10-15T09:43:35.000+0000 | -73.95847 | 40.765569 | -73.990547 | 40.693534 | 1 |
| 2009-01-24T22:53:01.000+0000 | 6.6 | 2009-01-24T22:53:01.000+0000 | -73.994021 | 40.75129 | -73.97253 | 40.749632 | 1 |
| 2009-03-15T02:15:39.000+0000 | 53.0 | 2009-03-15T02:15:39.000+0000 | -73.993309 | 40.719976 | -74.040465 | 40.725234 | 1 |
| 2009-06-29T11:45:00.000+0000 | 15.3 | 2009-06-29T11:45:00.000+0000 | -73.9757 | 40.751598 | -74.0163 | 40.704697 | 1 |
| 2010-11-25T00:41:00.000+0000 | 6.1 | 2010-11-25T00:41:00.000+0000 | -73.992275 | 40.734648 | -74.003982 | 40.747582 | 5 |
| 2011-08-08T09:59:00.000+0000 | 7.3 | 2011-08-08T09:59:00.000+0000 | -73.96252 | 40.776573 | -73.975502 | 40.757275 | 1 |
| 2013-12-23T13:52:00.000+0000 | 30.83 | 2013-12-23T13:52:00.000+0000 | -73.952607 | 40.776032 | -73.861117 | 40.767782 | 1 |
| 2012-07-05T00:29:21.000+0000 | 6.5 | 2012-07-05T00:29:21.000+0000 | -73.988026 | 40.765026 | -73.975303 | 40.787134 | 2 |
| 2014-01-18T15:23:00.000+0000 | 4.5 | 2014-01-18T15:23:00.000+0000 | -73.96421 | 40.77061 | -73.96993 | 40.762597 | 1 |
| 2015-01-11T11:09:26.000+0000 | 5.5 | 2015-01-11T11:09:26.000+0000 | -73.98262023925781 | 40.74237060546875 | -73.99588012695312 | 40.73276138305664 | 6 |
| 2009-01-03T13:27:00.000+0000 | 3.7 | 2009-01-03T13:27:00.000+0000 | -73.963823 | 40.774163 | -73.957648 | 40.782628 | 1 |
| 2010-12-04T23:56:00.000+0000 | 4.1 | 2010-12-04T23:56:00.000+0000 | -73.9784 | 40.783223 | -73.98173 | 40.778902 | 1 |
| 2012-03-07T09:29:44.000+0000 | 3.3 | 2012-03-07T09:29:44.000+0000 | -73.965352 | 40.769132 | -73.967953 | 40.76573 | 1 |
| 2012-10-13T02:31:22.000+0000 | 31.5 | 2012-10-13T02:31:22.000+0000 | -74.007458 | 40.726242 | -73.870459 | 40.762649 | 1 |
| 2013-04-18T20:48:24.000+0000 | 7.0 | 2013-04-18T20:48:24.000+0000 | -73.995001 | 40.760205 | -73.986058 | 40.778839 | 1 |
| 2011-11-11T04:06:20.000+0000 | 9.7 | 2011-11-11T04:06:20.000+0000 | -74.002499 | 40.733322 | -73.966174 | 40.765409 | 1 |
| 2012-05-26T01:15:11.000+0000 | 12.1 | 2012-05-26T01:15:11.000+0000 | -73.987243 | 40.72241 | -73.97162 | 40.76199 | 1 |
| 2013-06-06T16:32:59.000+0000 | 10.5 | 2013-06-06T16:32:59.000+0000 | -73.952881 | 40.783467 | -73.957899 | 40.770332 | 2 |
| 2010-11-09T14:41:00.000+0000 | 4.5 | 2010-11-09T14:41:00.000+0000 | -74.000607 | 40.732278 | -73.991617 | 40.73513 | 1 |
| 2011-03-03T14:15:00.000+0000 | 8.1 | 2011-03-03T14:15:00.000+0000 | -73.95199 | 40.77783 | -73.960187 | 40.765442 | 1 |
| 2011-11-24T04:23:08.000+0000 | 4.9 | 2011-11-24T04:23:08.000+0000 | -73.992445 | 40.721134 | -73.981646 | 40.714442 | 4 |
| 2013-05-30T10:54:32.000+0000 | 8.5 | 2013-05-30T10:54:32.000+0000 | -73.989321 | 40.757413 | -73.968748 | 40.761164 | 1 |
| 2014-01-27T16:04:00.000+0000 | 7.0 | 2014-01-27T16:04:00.000+0000 | -73.9555 | 40.781842 | -73.970527 | 40.783687 | 1 |
| 2014-07-01T13:16:00.000+0000 | 5.5 | 2014-07-01T13:16:00.000+0000 | -73.974778 | 40.7831 | -73.985705 | 40.778307 | 1 |
| 2009-04-08T07:37:00.000+0000 | 4.9 | 2009-04-08T07:37:00.000+0000 | -74.001212 | 40.74134 | -73.986977 | 40.740538 | 1 |
| 2009-06-09T17:02:35.000+0000 | 6.1 | 2009-06-09T17:02:35.000+0000 | -73.987769 | 40.750038 | -73.980449 | 40.761698 | 3 |
| 2010-05-03T20:30:32.000+0000 | 7.3 | 2010-05-03T20:30:32.000+0000 | -73.976538 | 40.755762 | -73.959461 | 40.763329 | 1 |
| 2011-05-25T22:41:33.000+0000 | 12.1 | 2011-05-25T22:41:33.000+0000 | -73.983548 | 40.726099 | -73.984399 | 40.691472 | 3 |
| 2011-09-25T02:07:00.000+0000 | 8.5 | 2011-09-25T02:07:00.000+0000 | 0.0 | 0.0 | 0.0 | 0.0 | 1 |
| 2009-05-13T07:43:00.000+0000 | 6.9 | 2009-05-13T07:43:00.000+0000 | -73.981818 | 40.783335 | -73.96748 | 40.803038 | 1 |
| 2009-06-24T19:42:01.000+0000 | 13.7 | 2009-06-24T19:42:01.000+0000 | -74.001837 | 40.732437 | -73.957734 | 40.769518 | 1 |
| 2011-06-06T13:16:00.000+0000 | 3.3 | 2011-06-06T13:16:00.000+0000 | -73.972987 | 40.7904 | -73.96814 | 40.797218 | 1 |
| 2013-08-13T22:05:00.000+0000 | 5.5 | 2013-08-13T22:05:00.000+0000 | -73.984833 | 40.724207 | -73.986985 | 40.733497 | 1 |
| 2014-04-16T19:14:55.000+0000 | 11.5 | 2014-04-16T19:14:55.000+0000 | -73.982912 | 40.76426 | -73.990407 | 40.75069 | 1 |
| 2015-05-23T21:29:14.000+0000 | 4.5 | 2015-05-23T21:29:14.000+0000 | -73.98357391357422 | 40.76544189453125 | -73.9754638671875 | 40.76521682739258 | 1 |
| 2010-05-27T01:32:00.000+0000 | 16.1 | 2010-05-27T01:32:00.000+0000 | -73.981497 | 40.776205 | -74.01464 | 40.708183 | 1 |
| 2011-06-01T22:39:35.000+0000 | 11.7 | 2011-06-01T22:39:35.000+0000 | -73.992091 | 40.748239 | -73.952414 | 40.772895 | 1 |
| 2011-07-19T23:43:12.000+0000 | 8.5 | 2011-07-19T23:43:12.000+0000 | 0.0 | 0.0 | 0.0 | 0.0 | 1 |
| 2014-09-22T17:08:00.000+0000 | 9.0 | 2014-09-22T17:08:00.000+0000 | -73.99801 | 40.75608 | -73.98273 | 40.77334 | 1 |
| 2009-11-27T14:39:33.000+0000 | 6.5 | 2009-11-27T14:39:33.000+0000 | -73.964714 | 40.769757 | -73.982117 | 40.774973 | 1 |
| 2013-03-23T12:37:00.000+0000 | 5.0 | 2013-03-23T12:37:00.000+0000 | -74.000407 | 40.714337 | -74.000503 | 40.718452 | 1 |
| 2009-01-17T19:51:14.000+0000 | 6.1 | 2009-01-17T19:51:14.000+0000 | -73.955641 | 40.772606 | -73.971135 | 40.755318 | 1 |
| 2013-08-17T22:34:59.000+0000 | 12.0 | 2013-08-17T22:34:59.000+0000 | -73.991512 | 40.726929 | -73.977929 | 40.763074 | 1 |
| 2014-09-26T19:41:41.000+0000 | 12.0 | 2014-09-26T19:41:41.000+0000 | 0.0 | 0.0 | 0.0 | 0.0 | 1 |
| 2014-11-02T21:21:45.000+0000 | 8.5 | 2014-11-02T21:21:45.000+0000 | -73.980556 | 40.748284 | -73.999545 | 40.728622 | 1 |
| 2015-01-17T21:00:44.000+0000 | 9.0 | 2015-01-17T21:00:44.000+0000 | -73.9662857055664 | 40.76172637939453 | -73.96056365966798 | 40.7702751159668 | 1 |
| 2010-04-02T03:08:00.000+0000 | 13.3 | 2010-04-02T03:08:00.000+0000 | -73.992338 | 40.724155 | -73.931653 | 40.699268 | 1 |
| 2010-04-16T21:07:02.000+0000 | 9.7 | 2010-04-16T21:07:02.000+0000 | -73.99171 | 40.758915 | -73.988093 | 40.733613 | 1 |
| 2012-03-04T22:43:44.000+0000 | 5.3 | 2012-03-04T22:43:44.000+0000 | -73.99716 | 40.742155 | -74.005573 | 40.726273 | 1 |
| 2012-07-10T09:37:00.000+0000 | 10.5 | 2012-07-10T09:37:00.000+0000 | -73.983825 | 40.738307 | -73.957293 | 40.766155 | 1 |
| 2009-06-21T18:56:00.000+0000 | 8.9 | 2009-06-21T18:56:00.000+0000 | -74.004737 | 40.751987 | -73.974168 | 40.743227 | 5 |
| 2010-03-10T07:55:47.000+0000 | 13.7 | 2010-03-10T07:55:47.000+0000 | -73.992392 | 40.71515 | -73.971869 | 40.688143 | 1 |
| 2010-09-13T08:48:21.000+0000 | 8.1 | 2010-09-13T08:48:21.000+0000 | -73.975152 | 40.756832 | -73.965323 | 40.765873 | 1 |
| 2011-06-22T21:44:45.000+0000 | 10.9 | 2011-06-22T21:44:45.000+0000 | -74.014483 | 40.71451 | -73.982215 | 40.740178 | 1 |
| 2010-01-23T12:39:00.000+0000 | 6.1 | 2010-01-23T12:39:00.000+0000 | -73.986405 | 40.745185 | -73.989025 | 40.752668 | 1 |
| 2011-03-16T17:05:00.000+0000 | 4.9 | 2011-03-16T17:05:00.000+0000 | -73.964922 | 40.764382 | -73.954068 | 40.778877 | 1 |
| 2011-10-07T12:24:00.000+0000 | 5.7 | 2011-10-07T12:24:00.000+0000 | -73.971523 | 40.75743 | -73.98203 | 40.744883 | 2 |
| 2012-10-05T13:34:41.000+0000 | 6.0 | 2012-10-05T13:34:41.000+0000 | -73.956865 | 40.774874 | -73.955842 | 40.784669 | 1 |
| 2015-06-16T21:08:18.000+0000 | 6.5 | 2015-06-16T21:08:18.000+0000 | -73.9776840209961 | 40.7633056640625 | -73.97769165039062 | 40.75357437133789 | 1 |
| 2010-10-18T11:15:27.000+0000 | 5.7 | 2010-10-18T11:15:27.000+0000 | -73.993252 | 40.752388 | -73.987604 | 40.765374 | 1 |
| 2014-12-18T08:06:14.000+0000 | 6.0 | 2014-12-18T08:06:14.000+0000 | -73.988374 | 40.759217 | -73.991075 | 40.770689 | 1 |
| 2009-01-19T10:38:00.000+0000 | 3.7 | 2009-01-19T10:38:00.000+0000 | -73.98708 | 40.741545 | -73.990558 | 40.736778 | 1 |
| 2009-05-15T12:58:00.000+0000 | 4.9 | 2009-05-15T12:58:00.000+0000 | -73.965368 | 40.763128 | -73.956642 | 40.774873 | 1 |
| 2014-06-20T01:02:07.000+0000 | 7.0 | 2014-06-20T01:02:07.000+0000 | -73.995163 | 40.744714 | -73.999739 | 40.728509 | 1 |
| 2009-02-08T10:46:00.000+0000 | 10.9 | 2009-02-08T10:46:00.000+0000 | -73.998053 | 40.722607 | -73.96563 | 40.76218 | 1 |
| 2010-05-05T19:51:00.000+0000 | 6.5 | 2010-05-05T19:51:00.000+0000 | -73.951573 | 40.773733 | -73.959827 | 40.761932 | 1 |
| 2011-11-13T12:59:00.000+0000 | 13.3 | 2011-11-13T12:59:00.000+0000 | -73.955707 | 40.778757 | -73.990922 | 40.74053 | 1 |
| 2009-01-14T08:21:59.000+0000 | 4.1 | 2009-01-14T08:21:59.000+0000 | -73.986869 | 40.758182 | -73.977844 | 40.764209 | 1 |
| 2010-02-22T07:42:00.000+0000 | 6.9 | 2010-02-22T07:42:00.000+0000 | -73.996573 | 40.748843 | -73.995178 | 40.750753 | 1 |
| 2014-04-08T14:11:00.000+0000 | 15.0 | 2014-04-08T14:11:00.000+0000 | -73.966193 | 40.758177 | -73.991642 | 40.74908 | 1 |
| 2014-06-14T20:48:12.000+0000 | 22.5 | 2014-06-14T20:48:12.000+0000 | -73.991447 | 40.75005 | -73.934919 | 40.769477 | 2 |
| 2009-06-25T16:21:00.000+0000 | 12.1 | 2009-06-25T16:21:00.000+0000 | -74.007773 | 40.725133 | -73.971308 | 40.76391 | 1 |
| 2013-10-06T04:24:09.000+0000 | 20.0 | 2013-10-06T04:24:09.000+0000 | -73.960074 | 40.762443 | -73.991058 | 40.751086 | 1 |
| 2013-12-12T09:30:00.000+0000 | 15.0 | 2013-12-12T09:30:00.000+0000 | -73.989695 | 40.735492 | -73.97828 | 40.754775 | 1 |
| 2015-01-02T23:24:27.000+0000 | 8.5 | 2015-01-02T23:24:27.000+0000 | -73.97823333740233 | 40.76188659667969 | -73.99219512939453 | 40.748680114746094 | 3 |
| 2014-05-31T14:53:00.000+0000 | 5.5 | 2014-05-31T14:53:00.000+0000 | -73.991192 | 40.739212 | -74.00175 | 40.72844 | 1 |
| 2011-02-09T14:02:00.000+0000 | 4.9 | 2011-02-09T14:02:00.000+0000 | -73.987447 | 40.741957 | -73.977993 | 40.754168 | 2 |
| 2012-05-17T20:29:00.000+0000 | 4.9 | 2012-05-17T20:29:00.000+0000 | -73.986092 | 40.751682 | -73.977242 | 40.760292 | 1 |
| 2012-08-28T23:30:17.000+0000 | 2.5 | 2012-08-28T23:30:17.000+0000 | -73.959008 | 40.712517 | -73.959132 | 40.712184 | 1 |
| 2012-01-14T14:32:09.000+0000 | 10.5 | 2012-01-14T14:32:09.000+0000 | -73.952301 | 40.784013 | -73.973045 | 40.748868 | 1 |
| 2011-07-03T13:55:00.000+0000 | 5.7 | 2011-07-03T13:55:00.000+0000 | -73.989708 | 40.73873 | -73.997613 | 40.724167 | 2 |
| 2012-11-16T12:42:29.000+0000 | 11.0 | 2012-11-16T12:42:29.000+0000 | -73.950396 | 40.783667 | -73.961248 | 40.760961 | 1 |
| 2013-02-26T09:24:04.000+0000 | 10.0 | 2013-02-26T09:24:04.000+0000 | -73.94952 | 40.780422 | -73.972101 | 40.76229 | 1 |
| 2014-10-19T09:51:53.000+0000 | 57.33 | 2014-10-19T09:51:53.000+0000 | -73.776721 | 40.645324 | -73.983183 | 40.748877 | 2 |
| 2011-11-03T23:07:00.000+0000 | 49.8 | 2011-11-03T23:07:00.000+0000 | -73.78555 | 40.64205 | -73.980793 | 40.749187 | 1 |
| 2014-09-27T11:46:49.000+0000 | 8.5 | 2014-09-27T11:46:49.000+0000 | -73.992148 | 40.754051 | -73.975903 | 40.748717 | 1 |
| 2015-03-09T20:05:18.000+0000 | 13.5 | 2015-03-09T20:05:18.000+0000 | -73.96829223632812 | 40.76164245605469 | -73.99909973144531 | 40.7393684387207 | 1 |
| 2015-03-28T10:48:38.000+0000 | 5.0 | 2015-03-28T10:48:38.000+0000 | -73.9994125366211 | 40.74410629272461 | -73.98988342285155 | 40.747268676757805 | 1 |
| 2009-01-28T22:34:00.000+0000 | 6.5 | 2009-01-28T22:34:00.000+0000 | -73.994023 | 40.75171 | -73.976773 | 40.755773 | 1 |
| 2009-03-21T10:09:09.000+0000 | 12.9 | 2009-03-21T10:09:09.000+0000 | -73.972626 | 40.785846 | -73.994321 | 40.736666 | 1 |
| 2010-10-21T14:51:18.000+0000 | 6.1 | 2010-10-21T14:51:18.000+0000 | -73.997519 | 40.73614 | -74.007986 | 40.736214 | 1 |
| 2013-02-05T23:38:00.000+0000 | 3.5 | 2013-02-05T23:38:00.000+0000 | -74.01589 | 40.711205 | -74.013135 | 40.715037 | 2 |
| 2015-01-05T12:55:17.000+0000 | 9.0 | 2015-01-05T12:55:17.000+0000 | -73.98844909667967 | 40.7259407043457 | -73.98915100097656 | 40.72842025756836 | 1 |
| 2009-03-19T16:15:36.000+0000 | 6.7 | 2009-03-19T16:15:36.000+0000 | -74.000548 | 40.737311 | -73.993162 | 40.734975 | 1 |
| 2009-11-13T18:50:00.000+0000 | 5.3 | 2009-11-13T18:50:00.000+0000 | -73.951788 | 40.782128 | -73.961878 | 40.776735 | 1 |
| 2013-06-25T18:51:00.000+0000 | 5.5 | 2013-06-25T18:51:00.000+0000 | -73.963975 | 40.773902 | -73.95411 | 40.784472 | 1 |
| 2010-01-11T18:08:00.000+0000 | 7.7 | 2010-01-11T18:08:00.000+0000 | -73.985653 | 40.747188 | -73.98329 | 40.730267 | 1 |
| 2010-07-11T13:32:00.000+0000 | 12.9 | 2010-07-11T13:32:00.000+0000 | -73.97274 | 40.753488 | -74.006575 | 40.741452 | 1 |
| 2011-11-16T14:33:22.000+0000 | 4.5 | 2011-11-16T14:33:22.000+0000 | -73.958326 | 40.768777 | -73.95916 | 40.763442 | 2 |
| 2013-05-25T20:25:46.000+0000 | 9.5 | 2013-05-25T20:25:46.000+0000 | -73.986004 | 40.749766 | -74.003312 | 40.724212 | 1 |
| 2013-06-17T16:42:54.000+0000 | 6.0 | 2013-06-17T16:42:54.000+0000 | -73.98626 | 40.75845 | -73.982653 | 40.771674 | 3 |
| 2009-11-20T00:31:00.000+0000 | 6.1 | 2009-11-20T00:31:00.000+0000 | -73.988137 | 40.73474 | -73.983568 | 40.74645 | 1 |
| 2012-06-20T15:46:00.000+0000 | 12.1 | 2012-06-20T15:46:00.000+0000 | -73.985428 | 40.744102 | -73.958588 | 40.770407 | 2 |
| 2012-12-16T02:09:05.000+0000 | 10.5 | 2012-12-16T02:09:05.000+0000 | -73.91406 | 40.765092 | -73.950657 | 40.745017 | 1 |
| 2014-04-19T15:46:38.000+0000 | 8.0 | 2014-04-19T15:46:38.000+0000 | -73.994767 | 40.731799 | -73.986516 | 40.742846 | 1 |
| 2014-05-26T21:35:00.000+0000 | 8.5 | 2014-05-26T21:35:00.000+0000 | -73.977425 | 40.752052 | -73.9815 | 40.775147 | 2 |
| 2015-04-07T18:37:37.000+0000 | 12.5 | 2015-04-07T18:37:37.000+0000 | -73.97177124023438 | 40.755718231201165 | -73.97831726074217 | 40.76189422607422 | 1 |
| 2011-05-27T09:51:30.000+0000 | 4.5 | 2011-05-27T09:51:30.000+0000 | -74.005991 | 40.735314 | -73.998334 | 40.745446 | 1 |
| 2012-01-06T18:35:00.000+0000 | 13.3 | 2012-01-06T18:35:00.000+0000 | -74.006893 | 40.712272 | -73.989375 | 40.734032 | 5 |
| 2012-05-24T05:44:00.000+0000 | 6.9 | 2012-05-24T05:44:00.000+0000 | -73.999842 | 40.761572 | -73.982845 | 40.755652 | 1 |
| 2014-04-30T09:04:07.000+0000 | 3.5 | 2014-04-30T09:04:07.000+0000 | -74.005821 | 40.745254 | -74.000546 | 40.752709 | 1 |
| 2014-09-26T18:09:32.000+0000 | 9.5 | 2014-09-26T18:09:32.000+0000 | -73.959509 | 40.814332 | -73.939583 | 40.805312 | 1 |
| 2009-02-02T08:43:43.000+0000 | 22.1 | 2009-02-02T08:43:43.000+0000 | -73.996359 | 40.686204 | -73.972373 | 40.762092 | 1 |
| 2010-10-05T22:09:00.000+0000 | 5.3 | 2010-10-05T22:09:00.000+0000 | -74.00672 | 40.743813 | -73.994987 | 40.760258 | 1 |
| 2011-02-22T14:09:00.000+0000 | 2.5 | 2011-02-22T14:09:00.000+0000 | 0.0 | 0.0 | 0.0 | 0.0 | 5 |
| 2011-09-06T20:43:29.000+0000 | 6.5 | 2011-09-06T20:43:29.000+0000 | -73.987366 | 40.739465 | -74.002286 | 40.74703 | 1 |
| 2013-05-31T05:02:30.000+0000 | 12.5 | 2013-05-31T05:02:30.000+0000 | 0.0 | 0.0 | 0.0 | 0.0 | 1 |
| 2014-11-23T08:42:00.000+0000 | 10.0 | 2014-11-23T08:42:00.000+0000 | -73.926197 | 40.7624 | -73.966622 | 40.762552 | 1 |
| 2015-06-22T17:51:38.000+0000 | 24.5 | 2015-06-22T17:51:38.000+0000 | -73.99882507324217 | 40.749637603759766 | -74.0107421875 | 40.7095947265625 | 4 |
| 2009-02-06T23:31:00.000+0000 | 7.7 | 2009-02-06T23:31:00.000+0000 | -73.988933 | 40.757277 | -73.975883 | 40.742218 | 5 |
| 2009-06-30T10:20:09.000+0000 | 14.1 | 2009-06-30T10:20:09.000+0000 | 0.0 | 0.0 | 0.0 | 0.0 | 1 |
| 2010-07-12T10:50:00.000+0000 | 5.7 | 2010-07-12T10:50:00.000+0000 | -73.992488 | 40.730615 | -74.001482 | 40.717792 | 1 |
| 2015-06-08T01:59:17.000+0000 | 28.0 | 2015-06-08T01:59:17.000+0000 | 0.0 | 0.0 | 0.0 | 0.0 | 1 |
| 2009-01-27T15:18:00.000+0000 | 6.5 | 2009-01-27T15:18:00.000+0000 | -73.973787 | 40.747695 | -73.986315 | 40.746973 | 5 |
| 2009-03-01T16:45:25.000+0000 | 7.3 | 2009-03-01T16:45:25.000+0000 | -73.993656 | 40.75711 | -73.980168 | 40.741778 | 1 |
| 2011-10-26T23:00:42.000+0000 | 7.7 | 2011-10-26T23:00:42.000+0000 | -73.981439 | 40.760569 | -73.957854 | 40.779309 | 1 |
| 2013-12-12T19:02:08.000+0000 | 10.0 | 2013-12-12T19:02:08.000+0000 | -74.002595 | 40.737675 | -73.987135 | 40.729482 | 1 |
| 2010-11-21T01:41:00.000+0000 | 10.1 | 2010-11-21T01:41:00.000+0000 | -74.0045 | 40.742143 | -73.99433 | 40.720412 | 1 |
| 2011-03-11T18:13:00.000+0000 | 6.5 | 2011-03-11T18:13:00.000+0000 | -73.962018 | 40.779402 | -73.981495 | 40.773565 | 2 |
| 2014-08-18T06:22:11.000+0000 | 6.0 | 2014-08-18T06:22:11.000+0000 | -73.977999 | 40.778626 | -73.979161 | 40.764625 | 1 |
| 2015-01-08T11:44:11.000+0000 | 16.5 | 2015-01-08T11:44:11.000+0000 | -73.97943878173827 | 40.75250244140625 | -73.95565795898438 | 40.764102935791016 | 1 |
| 2015-05-26T17:54:52.000+0000 | 8.5 | 2015-05-26T17:54:52.000+0000 | -73.99092102050781 | 40.74221420288086 | -73.98013305664062 | 40.760738372802734 | 1 |
| 2011-12-24T11:45:00.000+0000 | 17.3 | 2011-12-24T11:45:00.000+0000 | -73.987938 | 40.76025 | -74.014335 | 40.70369 | 2 |
| 2012-10-10T07:49:23.000+0000 | 10.5 | 2012-10-10T07:49:23.000+0000 | -73.988581 | 40.764449 | -73.98576 | 40.739091 | 1 |
| 2015-04-09T22:57:02.000+0000 | 15.0 | 2015-04-09T22:57:02.000+0000 | -73.96577453613281 | 40.76523208618164 | -73.99700927734375 | 40.75635147094727 | 1 |
| 2013-06-07T22:20:00.000+0000 | 23.5 | 2013-06-07T22:20:00.000+0000 | -73.990597 | 40.75622 | -73.96239 | 40.719847 | 1 |
| 2011-10-24T22:54:00.000+0000 | 10.1 | 2011-10-24T22:54:00.000+0000 | -73.990602 | 40.7611 | -73.960025 | 40.77958 | 2 |
| 2011-11-21T18:49:00.000+0000 | 17.7 | 2011-11-21T18:49:00.000+0000 | -73.989503 | 40.753248 | -73.974107 | 40.795577 | 2 |
| 2014-10-16T17:27:00.000+0000 | 9.0 | 2014-10-16T17:27:00.000+0000 | -73.963035 | 40.772385 | -73.98132 | 40.77116 | 3 |
| 2009-06-12T10:34:00.000+0000 | 6.9 | 2009-06-12T10:34:00.000+0000 | -73.979668 | 40.739275 | -73.975107 | 40.756322 | 1 |
| 2012-06-17T01:41:00.000+0000 | 7.3 | 2012-06-17T01:41:00.000+0000 | -73.995732 | 40.724963 | -73.979377 | 40.751408 | 2 |
| 2012-12-27T23:22:00.000+0000 | 21.5 | 2012-12-27T23:22:00.000+0000 | -73.98495 | 40.759487 | -73.970597 | 40.694542 | 6 |
| 2010-02-02T12:40:32.000+0000 | 9.7 | 2010-02-02T12:40:32.000+0000 | -73.995494 | 40.752919 | -73.977412 | 40.743828 | 1 |
| 2012-05-28T19:31:00.000+0000 | 5.7 | 2012-05-28T19:31:00.000+0000 | -73.984202 | 40.744187 | -73.97462 | 40.761423 | 1 |
| 2015-05-14T22:42:43.000+0000 | 13.0 | 2015-05-14T22:42:43.000+0000 | -73.98090362548828 | 40.75609588623047 | -73.95862579345702 | 40.76633834838867 | 1 |
| 2013-02-27T16:08:15.000+0000 | 10.5 | 2013-02-27T16:08:15.000+0000 | -73.968574 | 40.750493 | -73.975654 | 40.755957 | 1 |
| 2015-03-31T07:09:18.000+0000 | 9.0 | 2015-03-31T07:09:18.000+0000 | -73.94857788085938 | 40.783203125 | -73.95526885986328 | 40.76516342163086 | 1 |
| 2011-10-05T20:50:00.000+0000 | 7.3 | 2011-10-05T20:50:00.000+0000 | -73.961407 | 40.765273 | -73.954393 | 40.78403 | 2 |
| 2014-05-14T07:32:00.000+0000 | 8.5 | 2014-05-14T07:32:00.000+0000 | -73.986492 | 40.734067 | -73.988017 | 40.752412 | 1 |
| 2015-02-06T14:44:35.000+0000 | 23.0 | 2015-02-06T14:44:35.000+0000 | -73.7870101928711 | 40.64413833618164 | -73.81063842773438 | 40.69221878051758 | 2 |
| 2009-03-24T11:37:00.000+0000 | 13.7 | 2009-03-24T11:37:00.000+0000 | -73.9881 | 40.754748 | -73.99727 | 40.72563 | 1 |
| 2011-07-30T07:33:13.000+0000 | 16.9 | 2011-07-30T07:33:13.000+0000 | -73.884801 | 40.755707 | -73.980472 | 40.765556 | 1 |
| 2011-09-24T23:20:00.000+0000 | 13.7 | 2011-09-24T23:20:00.000+0000 | -73.953603 | 40.779203 | -73.995763 | 40.726701 | 3 |
| 2011-12-22T11:07:00.000+0000 | 29.3 | 2011-12-22T11:07:00.000+0000 | -73.94238 | 40.837712 | -73.864372 | 40.769985 | 2 |
| 2014-11-03T12:40:00.000+0000 | 6.5 | 2014-11-03T12:40:00.000+0000 | -73.961151 | 40.774578 | -73.972251 | 40.78564 | 1 |
| 2012-05-18T18:41:30.000+0000 | 10.9 | 2012-05-18T18:41:30.000+0000 | -73.988455 | 40.758432 | -73.983816 | 40.730147 | 1 |
df.shape
df.describe()
| fare_amount | pickup_longitude | pickup_latitude | dropoff_longitude | dropoff_latitude | passenger_count | |
|---|---|---|---|---|---|---|
| count | 5.500000e+06 | 5.500000e+06 | 5.500000e+06 | 5.499964e+06 | 5.499964e+06 | 5.500000e+06 |
| mean | 1.134239e+01 | -7.250980e+01 | 3.992242e+01 | -7.250923e+01 | 3.991838e+01 | 1.684539e+00 |
| std | 9.819104e+00 | 1.281230e+01 | 9.023598e+00 | 1.283150e+01 | 9.250279e+00 | 1.329587e+00 |
| min | -1.000000e+02 | -3.426609e+03 | -3.488080e+03 | -3.412653e+03 | -3.488080e+03 | 0.000000e+00 |
| 25% | 6.000000e+00 | -7.399206e+01 | 4.073491e+01 | -7.399140e+01 | 4.073404e+01 | 1.000000e+00 |
| 50% | 8.500000e+00 | -7.398181e+01 | 4.075263e+01 | -7.398016e+01 | 4.075315e+01 | 1.000000e+00 |
| 75% | 1.250000e+01 | -7.396711e+01 | 4.076711e+01 | -7.396368e+01 | 4.076811e+01 | 2.000000e+00 |
| max | 1.273310e+03 | 3.439426e+03 | 3.344459e+03 | 3.457622e+03 | 3.345917e+03 | 2.080000e+02 |
df.info()
Convert object datatype to datetime64[ns]
df.key = df.key.astype('datetime64[ns]')
df.pickup_datetime = df.pickup_datetime.astype('datetime64[ns]')
test_df.key = test_df.key.astype('datetime64[ns]')
test_df.pickup_datetime = test_df.pickup_datetime.astype('datetime64[ns]')
Check and drop the null values
df.isna().sum().sort_values(ascending=False)
df.dropna(inplace=True)
Check and drop the records which have negative fare amount
df[df.fare_amount < 0].fare_amount
df.drop(df[df.fare_amount < 0].index, axis = 0, inplace = True)
Check and drop the records which have passenger count more than 6
df[df.passenger_count > 6]
| key | fare_amount | pickup_datetime | pickup_longitude | pickup_latitude | dropoff_longitude | dropoff_latitude | passenger_count | |
|---|---|---|---|---|---|---|---|---|
| 929022 | 2009-07-30 11:54:00 | 3.30 | 2009-07-30 11:54:00 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 208 |
| 1007609 | 2014-06-24 15:13:00 | 104.00 | 2014-06-24 15:13:00 | -74.015780 | 40.715420 | -74.170280 | 40.708340 | 9 |
| 2154045 | 2010-12-16 11:21:00 | 3.30 | 2010-12-16 11:21:00 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 208 |
| 2198549 | 2010-12-15 14:20:00 | 3.30 | 2010-12-15 14:20:00 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 208 |
| 2910347 | 2010-12-16 06:44:00 | 4.50 | 2010-12-16 06:44:00 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 208 |
| 3107489 | 2009-05-12 14:50:00 | 2.70 | 2009-05-12 14:50:00 | -73.937818 | 40.758260 | -73.937827 | 40.758250 | 208 |
| 3323791 | 2011-08-27 01:24:00 | 8.50 | 2011-08-27 01:24:00 | -73.987858 | 40.760340 | -74.000682 | 40.752413 | 129 |
| 4095440 | 2015-06-14 08:56:16 | 37.04 | 2015-06-14 08:56:16 | -73.982094 | 40.756252 | -73.872482 | 40.774506 | 9 |
| 4103745 | 2010-12-22 12:11:00 | 23.70 | 2010-12-22 12:11:00 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 208 |
| 4432483 | 2009-05-11 13:56:00 | 11.10 | 2009-05-11 13:56:00 | -73.937733 | 40.758267 | -73.937737 | 40.758273 | 208 |
| 4467314 | 2015-01-01 21:32:16 | 8.50 | 2015-01-01 21:32:16 | -74.005867 | 40.740643 | -73.988045 | 40.735100 | 7 |
| 4679603 | 2010-02-20 01:53:00 | 9.30 | 2010-02-20 01:53:00 | 0.554830 | 0.000000 | -2069.478952 | 28.121107 | 51 |
df.drop(df[df.passenger_count > 6].index, axis = 0, inplace = True)
Check the standard range of latitude and longitude, if value bound the range then drop
df.pickup_latitude.between(-90,90,inclusive=True).sum()
df.drop(df[df.pickup_latitude < -90].index, axis = 0, inplace = True)
df.drop(df[df.pickup_latitude > 90].index, axis = 0, inplace = True)
df.dropoff_latitude.between(-90,90,inclusive=True).sum()
df.drop(df[df.dropoff_latitude < -90].index, axis = 0, inplace = True)
df.drop(df[df.dropoff_latitude > 90].index, axis = 0, inplace = True)
df.pickup_longitude.between(-180,180,inclusive=True).sum()
df.drop(df[df.pickup_longitude < -180].index, axis = 0, inplace = True)
df.drop(df[df.pickup_longitude > 180].index, axis = 0, inplace = True)
df.dropoff_longitude.between(-180,180,inclusive=True).sum()
df.drop(df[df.dropoff_longitude < -180].index, axis = 0, inplace = True)
df.drop(df[df.dropoff_longitude > 180].index, axis = 0, inplace = True)
Function to calculate distance using haversine formula
def distance(data, lat1, long1, lat2, long2):
x = np.sin(np.radians(df[lat2]-df[lat1])/2.0) ** 2 + np.cos(np.radians(df[lat1])) * np.cos(np.radians(df[lat2])) * \
np.sin(np.radians(df[long2]-df[long1])/2.0) ** 2
y = 2 * np.arctan2(np.sqrt(x), np.sqrt(1 - x))
data['distance'] = 3959 * y
pass
distance(df, 'pickup_latitude', 'pickup_longitude', 'dropoff_latitude', 'dropoff_longitude')
Feature scaling of pickup datetime
df['year'] = df.pickup_datetime.dt.year
df['month'] = df.pickup_datetime.dt.month
df['date'] = df.pickup_datetime.dt.day
df['day_of_week'] = df.pickup_datetime.dt.dayofweek
df['hour'] = df.pickup_datetime.dt.hour
Histogram of fare amount
Hist = [go.Histogram(x=df.fare_amount[:1000000])]
layout = go.Layout(title = 'Fare Amount')
fig = go.Figure(data = Hist, layout = layout)
iplot(fig)
Scatterplot of passenger count and fare amount
plt.figure(figsize=(15,7))
plt.scatter(x=df.passenger_count, y=df.fare_amount)
plt.xlabel('Passenger Count')
plt.ylabel('Fare')
Scatterplot of date and fare amount
plt.figure(figsize=(15,7))
plt.scatter(x=df.date, y=df.fare_amount, s=1.5)
plt.xlabel('Date')
plt.ylabel('Fare')
Scatterplot of hour and fare
plt.figure(figsize=(15,7))
plt.scatter(x=df.hour, y=df.fare_amount)
plt.xlabel('Hour')
plt.ylabel('Fare')
Scatterplot of fare amount vs day of week
plt.figure(figsize=(15,7))
plt.scatter(x=df.day_of_week, y=df.fare_amount, s=1.5)
plt.xlabel('Day of Week')
plt.ylabel('Fare')
Relation between distance and fare
plt.figure(figsize=(16,10))
plt.scatter(x=df.distance, y=df.fare_amount, s=1.5)
plt.xlabel('Distance')
plt.ylabel('Fare')
Distribution of distance relative to fare and linear patterns in the distance
fig, axs = plt.subplots(1, 2, figsize=(18,7))
axs[0].scatter(df.distance, df.fare_amount, alpha=0.2)
axs[0].set_xlabel('Distance')
axs[0].set_ylabel('Fare')
axs[0].set_title('All data')
idx = (df.distance < 10) & (df.fare_amount < 75)
axs[1].scatter(df[idx].distance, df[idx].fare_amount, alpha=0.2)
axs[1].set_xlabel('Distance')
axs[1].set_ylabel('Fare')
axs[1].set_title('Distance < 10 mile, fare < $75');
Scenario
Pickup latitude and longitude are 0, Dropoff latitude and longitude are not 0 but fare amount is 0
vice versa.
df.drop(df.loc[((df.pickup_latitude == 0) & (df.pickup_longitude == 0))&((df.dropoff_latitude != 0) & (df.dropoff_longitude != 0)) & (df.fare_amount == 0)].index, axis = 0, inplace = True)
df.drop(df.loc[((df.pickup_latitude != 0) & (df.pickup_longitude != 0))&((df.dropoff_latitude == 0) & (df.dropoff_longitude == 0)) & (df.fare_amount == 0)].index, axis = 0, inplace = True)
There are so many irrelevant records in the correlation of distance and fare.
So as per the statistics of the data available for the new york city, base fare for the taxi ride is $2.5 and average $1.56 per mile.
Fare = (Distance
*1.56) + 2.5
Check the records if the distance is above 200 and fare amount is not equal to 0
distance_check = df.loc[(df.distance > 200)&(df.fare_amount != 0)]
distance_check
| key | fare_amount | pickup_datetime | pickup_longitude | pickup_latitude | dropoff_longitude | dropoff_latitude | passenger_count | distance | year | month | date | day_of_week | hour | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 472 | 2009-02-22 22:48:00 | 2.5 | 2009-02-22 22:48:00 | 0.000000 | 0.000000 | -74.005433 | 40.726685 | 2 | 5385.945749 | 2009 | 2 | 22 | 6 | 22 |
| 1260 | 2011-03-10 20:25:00 | 5.7 | 2011-03-10 20:25:00 | -73.973907 | 40.754743 | 0.000000 | 0.000000 | 2 | 5384.680323 | 2011 | 3 | 10 | 3 | 20 |
| 2280 | 2011-08-29 08:24:00 | 8.9 | 2011-08-29 08:24:00 | -73.936667 | 40.757815 | 0.000000 | 40.757815 | 1 | 3744.920829 | 2011 | 8 | 29 | 0 | 8 |
| 2397 | 2012-06-24 17:11:10 | 45.0 | 2012-06-24 17:11:10 | 0.000000 | 0.000000 | -74.010230 | 40.714553 | 2 | 5386.038620 | 2012 | 6 | 24 | 6 | 17 |
| 4278 | 2015-04-07 23:33:02 | 7.0 | 2015-04-07 23:33:02 | -73.972702 | 40.757423 | 0.000000 | 0.000000 | 1 | 5384.652471 | 2015 | 4 | 7 | 1 | 23 |
| ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
| 5498033 | 2013-01-16 13:50:32 | 56.8 | 2013-01-16 13:50:32 | 0.000000 | 0.000000 | -73.782726 | 40.648842 | 2 | 5373.483411 | 2013 | 1 | 16 | 2 | 13 |
| 5498148 | 2015-04-25 16:06:45 | 13.5 | 2015-04-25 16:06:45 | 0.000000 | 0.000000 | -73.984329 | 40.737274 | 2 | 5384.994227 | 2015 | 4 | 25 | 5 | 16 |
| 5498288 | 2012-06-21 13:17:00 | 9.3 | 2012-06-21 13:17:00 | -73.993742 | 40.759005 | -73.993490 | 0.004457 | 2 | 2816.040848 | 2012 | 6 | 21 | 3 | 13 |
| 5498957 | 2012-07-13 13:50:00 | 7.7 | 2012-07-13 13:50:00 | -7.978857 | 40.741195 | -74.000840 | 40.739035 | 1 | 3369.164958 | 2012 | 7 | 13 | 4 | 13 |
| 5499385 | 2012-01-16 17:10:00 | 5.3 | 2012-01-16 17:10:00 | 0.000000 | 40.723482 | -73.983288 | 40.725175 | 1 | 3749.152425 | 2012 | 1 | 16 | 0 | 17 |
11145 rows × 14 columns
Update all the records with correct values if satisfy the above condition
distance_check.distance = distance_check.apply(lambda x: (x.fare_amount - 2.50) / 1.56, axis = 1)
df.update(distance_check)
Check if both distance and fare are 0 then it should be dropped
df[(df.distance == 0) & (df.fare_amount == 0)]
| key | fare_amount | pickup_datetime | pickup_longitude | pickup_latitude | dropoff_longitude | dropoff_latitude | passenger_count | distance | year | month | date | day_of_week | hour | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 105051 | 2013-08-21 21:41:00 | 0.0 | 2013-08-21 21:41:00 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 2.0 | 0.0 | 2013.0 | 8.0 | 21.0 | 2.0 | 21.0 |
| 331597 | 2013-08-05 06:45:54 | 0.0 | 2013-08-05 06:45:54 | -73.982354 | 40.679971 | -73.982354 | 40.679971 | 1.0 | 0.0 | 2013.0 | 8.0 | 5.0 | 0.0 | 6.0 |
| 436658 | 2015-03-04 22:33:39 | 0.0 | 2015-03-04 22:33:39 | -74.043442 | 40.788208 | -74.043442 | 40.788208 | 1.0 | 0.0 | 2015.0 | 3.0 | 4.0 | 2.0 | 22.0 |
| 689250 | 2015-05-27 23:10:03 | 0.0 | 2015-05-27 23:10:03 | -73.994125 | 40.741131 | -73.994125 | 40.741131 | 1.0 | 0.0 | 2015.0 | 5.0 | 27.0 | 2.0 | 23.0 |
| 1221438 | 2015-02-02 21:58:28 | 0.0 | 2015-02-02 21:58:28 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 2.0 | 0.0 | 2015.0 | 2.0 | 2.0 | 0.0 | 21.0 |
| 1598058 | 2013-08-06 11:12:00 | 0.0 | 2013-08-06 11:12:00 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 2.0 | 0.0 | 2013.0 | 8.0 | 6.0 | 1.0 | 11.0 |
| 1662545 | 2010-03-13 02:39:29 | 0.0 | 2010-03-13 02:39:29 | -74.035278 | 40.738683 | -74.035278 | 40.738683 | 2.0 | 0.0 | 2010.0 | 3.0 | 13.0 | 5.0 | 2.0 |
| 2214498 | 2010-02-03 11:44:07 | 0.0 | 2010-02-03 11:44:07 | -74.014147 | 40.710546 | -74.014147 | 40.710546 | 1.0 | 0.0 | 2010.0 | 2.0 | 3.0 | 2.0 | 11.0 |
| 2329503 | 2015-02-19 09:43:11 | 0.0 | 2015-02-19 09:43:11 | -73.953857 | 40.813251 | -73.953857 | 40.813251 | 1.0 | 0.0 | 2015.0 | 2.0 | 19.0 | 3.0 | 9.0 |
| 2581417 | 2015-05-07 19:12:43 | 0.0 | 2015-05-07 19:12:43 | -73.913727 | 40.779018 | -73.913727 | 40.779018 | 1.0 | 0.0 | 2015.0 | 5.0 | 7.0 | 3.0 | 19.0 |
| 2618454 | 2015-03-26 05:43:22 | 0.0 | 2015-03-26 05:43:22 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 1.0 | 0.0 | 2015.0 | 3.0 | 26.0 | 3.0 | 5.0 |
| 2991619 | 2015-01-15 14:49:08 | 0.0 | 2015-01-15 14:49:08 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 1.0 | 0.0 | 2015.0 | 1.0 | 15.0 | 3.0 | 14.0 |
| 3070651 | 2015-01-25 20:54:02 | 0.0 | 2015-01-25 20:54:02 | -73.981293 | 40.769012 | -73.981293 | 40.769012 | 1.0 | 0.0 | 2015.0 | 1.0 | 25.0 | 6.0 | 20.0 |
| 3252539 | 2015-01-14 10:15:51 | 0.0 | 2015-01-14 10:15:51 | -73.937508 | 40.758129 | -73.937508 | 40.758129 | 1.0 | 0.0 | 2015.0 | 1.0 | 14.0 | 2.0 | 10.0 |
| 3712453 | 2010-03-29 12:47:22 | 0.0 | 2010-03-29 12:47:22 | -73.836776 | 40.869879 | -73.836776 | 40.869879 | 1.0 | 0.0 | 2010.0 | 3.0 | 29.0 | 0.0 | 12.0 |
| 4191567 | 2010-02-22 01:02:16 | 0.0 | 2010-02-22 01:02:16 | -73.981984 | 40.757467 | -73.981984 | 40.757467 | 1.0 | 0.0 | 2010.0 | 2.0 | 22.0 | 0.0 | 1.0 |
| 4307073 | 2010-02-13 00:30:23 | 0.0 | 2010-02-13 00:30:23 | -73.968945 | 40.764540 | -73.968945 | 40.764540 | 1.0 | 0.0 | 2010.0 | 2.0 | 13.0 | 5.0 | 0.0 |
| 4322959 | 2015-03-25 07:20:55 | 0.0 | 2015-03-25 07:20:55 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 5.0 | 0.0 | 2015.0 | 3.0 | 25.0 | 2.0 | 7.0 |
| 4377466 | 2015-01-16 14:56:36 | 0.0 | 2015-01-16 14:56:36 | -73.937531 | 40.758289 | -73.937531 | 40.758289 | 1.0 | 0.0 | 2015.0 | 1.0 | 16.0 | 4.0 | 14.0 |
| 4383356 | 2013-08-17 13:55:00 | 0.0 | 2013-08-17 13:55:00 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 2.0 | 0.0 | 2013.0 | 8.0 | 17.0 | 5.0 | 13.0 |
| 4819787 | 2015-02-18 06:47:03 | 0.0 | 2015-02-18 06:47:03 | -73.937820 | 40.758190 | -73.937820 | 40.758190 | 1.0 | 0.0 | 2015.0 | 2.0 | 18.0 | 2.0 | 6.0 |
| 4851000 | 2010-02-10 20:18:01 | 0.0 | 2010-02-10 20:18:01 | -74.003095 | 40.743403 | -74.003095 | 40.743403 | 1.0 | 0.0 | 2010.0 | 2.0 | 10.0 | 2.0 | 20.0 |
| 5406596 | 2015-04-21 03:41:29 | 0.0 | 2015-04-21 03:41:29 | -73.937439 | 40.758160 | -73.937439 | 40.758160 | 1.0 | 0.0 | 2015.0 | 4.0 | 21.0 | 1.0 | 3.0 |
df.drop(df[(df.distance == 0) & (df.fare_amount == 0)].index, axis = 0, inplace = True)
Check the fare amount is less than the base amount in the working days then drop it
df.loc[(((df.hour >= 6) & (df.hour <= 20)) & ((df.day_of_week >= 1) & (df.day_of_week <= 5)) & (df.distance == 0) & (df.fare_amount < 2.5))]
| key | fare_amount | pickup_datetime | pickup_longitude | pickup_latitude | dropoff_longitude | dropoff_latitude | passenger_count | distance | year | month | date | day_of_week | hour | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 830616 | 2015-01-21 06:29:21 | 0.01 | 2015-01-21 06:29:21 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 1.0 | 0.0 | 2015.0 | 1.0 | 21.0 | 2.0 | 6.0 |
| 925892 | 2015-01-21 14:12:00 | 1.90 | 2015-01-21 14:12:00 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 1.0 | 0.0 | 2015.0 | 1.0 | 21.0 | 2.0 | 14.0 |
| 1112195 | 2015-03-25 14:55:38 | 1.60 | 2015-03-25 14:55:38 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 2.0 | 0.0 | 2015.0 | 3.0 | 25.0 | 2.0 | 14.0 |
| 1215355 | 2015-05-29 18:15:27 | 2.00 | 2015-05-29 18:15:27 | -73.903214 | 40.747318 | -73.903214 | 40.747318 | 1.0 | 0.0 | 2015.0 | 5.0 | 29.0 | 4.0 | 18.0 |
| 2097377 | 2013-08-30 15:11:00 | 0.50 | 2013-08-30 15:11:00 | -121.340000 | 38.903350 | -121.340000 | 38.903350 | 1.0 | 0.0 | 2013.0 | 8.0 | 30.0 | 4.0 | 15.0 |
| 2322071 | 2010-02-25 12:44:00 | 1.25 | 2010-02-25 12:44:00 | -73.937722 | 40.758318 | -73.937722 | 40.758318 | 5.0 | 0.0 | 2010.0 | 2.0 | 25.0 | 3.0 | 12.0 |
| 2949904 | 2015-01-22 13:34:00 | 2.00 | 2015-01-22 13:34:00 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 1.0 | 0.0 | 2015.0 | 1.0 | 22.0 | 3.0 | 13.0 |
| 3010346 | 2015-01-23 08:50:38 | 0.01 | 2015-01-23 08:50:38 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 1.0 | 0.0 | 2015.0 | 1.0 | 23.0 | 4.0 | 8.0 |
| 4112515 | 2015-04-15 20:12:10 | 0.01 | 2015-04-15 20:12:10 | -73.994553 | 40.750240 | -73.994553 | 40.750240 | 1.0 | 0.0 | 2015.0 | 4.0 | 15.0 | 2.0 | 20.0 |
| 4920415 | 2013-08-09 18:39:00 | 1.50 | 2013-08-09 18:39:00 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 1.0 | 0.0 | 2013.0 | 8.0 | 9.0 | 4.0 | 18.0 |
| 5425695 | 2015-02-05 17:02:10 | 0.01 | 2015-02-05 17:02:10 | -73.866501 | 40.770050 | -73.866501 | 40.770050 | 1.0 | 0.0 | 2015.0 | 2.0 | 5.0 | 3.0 | 17.0 |
df.drop(df.loc[(((df.hour >= 6) & (df.hour <= 20)) & ((df.day_of_week >= 1) & (df.day_of_week <= 5)) &
(df.distance == 0) & (df.fare_amount < 2.5))].index, axis = 0, inplace = True)
Check and drop the records if fare is less than base amount on the weekends
df.loc[((df.day_of_week == 0) | (df.day_of_week == 6)) & (df.distance == 0) & (df.fare_amount < 2.5)]
| key | fare_amount | pickup_datetime | pickup_longitude | pickup_latitude | dropoff_longitude | dropoff_latitude | passenger_count | distance | year | month | date | day_of_week | hour | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2414636 | 2015-01-12 21:09:25 | 1.0 | 2015-01-12 21:09:25 | -73.880669 | 40.740891 | -73.880669 | 40.740891 | 1.0 | 0.0 | 2015.0 | 1.0 | 12.0 | 0.0 | 21.0 |
df.drop(df.loc[((df.day_of_week == 0) | (df.day_of_week == 6)) & (df.distance == 0) & (df.fare_amount < 2.5)].index, axis = 0, inplace = True)
Check if fare is 0 but distance is not 0 then impute it with mathematical calculation
fare_check = df.loc[(df.fare_amount == 0) & (df.distance != 0)]
fare_check.sort_values('distance',ascending = False)
| key | fare_amount | pickup_datetime | pickup_longitude | pickup_latitude | dropoff_longitude | dropoff_latitude | passenger_count | distance | year | month | date | day_of_week | hour | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3614406 | 2015-05-12 08:28:24 | 0.0 | 2015-05-12 08:28:24 | -73.820679 | 40.665684 | -74.181442 | 40.687679 | 1.0 | 18.966283 | 2015.0 | 5.0 | 12.0 | 1.0 | 8.0 |
| 5325349 | 2015-02-07 01:58:09 | 0.0 | 2015-02-07 01:58:09 | -74.009926 | 40.736710 | -74.282852 | 40.614143 | 3.0 | 16.621915 | 2015.0 | 2.0 | 7.0 | 5.0 | 1.0 |
| 1107618 | 2015-05-31 01:52:15 | 0.0 | 2015-05-31 01:52:15 | -73.997482 | 40.758915 | -74.144936 | 40.946930 | 4.0 | 15.105223 | 2015.0 | 5.0 | 31.0 | 6.0 | 1.0 |
| 3763201 | 2010-03-05 21:43:42 | 0.0 | 2010-03-05 21:43:42 | -73.786049 | 40.641929 | -73.981236 | 40.782779 | 4.0 | 14.114868 | 2010.0 | 3.0 | 5.0 | 4.0 | 21.0 |
| 1902135 | 2010-03-08 20:23:36 | 0.0 | 2010-03-08 20:23:36 | -73.786727 | 40.640482 | -73.979946 | 40.762910 | 5.0 | 13.191238 | 2010.0 | 3.0 | 8.0 | 0.0 | 20.0 |
| ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
| 211499 | 2010-03-08 18:22:00 | 0.0 | 2010-03-08 18:22:00 | -73.937353 | 40.758227 | -73.937358 | 40.758230 | 1.0 | 0.000334 | 2010.0 | 3.0 | 8.0 | 0.0 | 18.0 |
| 2771692 | 2015-05-31 04:40:53 | 0.0 | 2015-05-31 04:40:53 | -73.896584 | 40.752499 | -73.896584 | 40.752502 | 1.0 | 0.000264 | 2015.0 | 5.0 | 31.0 | 6.0 | 4.0 |
| 495273 | 2015-05-26 12:28:03 | 0.0 | 2015-05-26 12:28:03 | -73.986473 | 40.721909 | -73.986473 | 40.721905 | 1.0 | 0.000264 | 2015.0 | 5.0 | 26.0 | 1.0 | 12.0 |
| 670254 | 2015-02-22 19:26:37 | 0.0 | 2015-02-22 19:26:37 | -73.994370 | 40.750725 | -73.994370 | 40.750721 | 1.0 | 0.000264 | 2015.0 | 2.0 | 22.0 | 6.0 | 19.0 |
| 4942824 | 2013-08-20 13:54:39 | 0.0 | 2013-08-20 13:54:39 | -74.002551 | 40.733974 | -74.002555 | 40.733975 | 6.0 | 0.000221 | 2013.0 | 8.0 | 20.0 | 1.0 | 13.0 |
100 rows × 14 columns
fare_check.fare_amount = fare_check.apply(lambda x: ((x.distance * 1.56) + 2.5), axis = 1)
df.update(fare_check)
Check if fare is above 3 but distance is equal to 0 then correct the distance according to the fare
dist_check = df.loc[(df.fare_amount > 3) & (df.distance == 0)]
dist_check.sort_values('fare_amount',ascending = False)
| key | fare_amount | pickup_datetime | pickup_longitude | pickup_latitude | dropoff_longitude | dropoff_latitude | passenger_count | distance | year | month | date | day_of_week | hour | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1144706 | 2015-03-09 15:12:00 | 1273.31 | 2015-03-09 15:12:00 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 1.0 | 0.0 | 2015.0 | 3.0 | 9.0 | 0.0 | 15.0 |
| 3723759 | 2015-03-10 09:48:00 | 698.16 | 2015-03-10 09:48:00 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 1.0 | 0.0 | 2015.0 | 3.0 | 10.0 | 1.0 | 9.0 |
| 101885 | 2011-09-12 09:33:56 | 500.00 | 2011-09-12 09:33:56 | -73.965961 | 40.640595 | -73.965961 | 40.640595 | 1.0 | 0.0 | 2011.0 | 9.0 | 12.0 | 0.0 | 9.0 |
| 3770478 | 2013-01-21 03:57:00 | 300.25 | 2013-01-21 03:57:00 | -73.990137 | 40.756872 | -73.990137 | 40.756872 | 1.0 | 0.0 | 2013.0 | 1.0 | 21.0 | 0.0 | 3.0 |
| 2427679 | 2015-01-03 03:57:26 | 300.00 | 2015-01-03 03:57:26 | -73.969688 | 40.592640 | -73.969688 | 40.592640 | 1.0 | 0.0 | 2015.0 | 1.0 | 3.0 | 5.0 | 3.0 |
| ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
| 4828186 | 2011-05-12 09:39:20 | 3.30 | 2011-05-12 09:39:20 | -73.983423 | 40.744259 | -73.983423 | 40.744259 | 1.0 | 0.0 | 2011.0 | 5.0 | 12.0 | 3.0 | 9.0 |
| 366224 | 2009-07-30 10:05:21 | 3.30 | 2009-07-30 10:05:21 | -73.137393 | 41.366138 | -73.137393 | 41.366138 | 1.0 | 0.0 | 2009.0 | 7.0 | 30.0 | 3.0 | 10.0 |
| 4125935 | 2011-08-02 16:57:00 | 3.30 | 2011-08-02 16:57:00 | -73.982505 | 40.735358 | -73.982505 | 40.735358 | 2.0 | 0.0 | 2011.0 | 8.0 | 2.0 | 1.0 | 16.0 |
| 3841998 | 2013-05-22 10:28:00 | 3.27 | 2013-05-22 10:28:00 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 1.0 | 0.0 | 2013.0 | 5.0 | 22.0 | 2.0 | 10.0 |
| 4724757 | 2013-12-13 08:36:00 | 3.25 | 2013-12-13 08:36:00 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 1.0 | 0.0 | 2013.0 | 12.0 | 13.0 | 4.0 | 8.0 |
149777 rows × 14 columns
dist_check.distance = dist_check.apply(lambda x: ((x.distance - 2.5) / 1.56), axis = 1)
df.update(dist_check)
Check if distance is above 100 but fare is still lower than 100, then fare should be imputed with correct values
target_check = df.loc[(df.fare_amount < 100) & (df.distance > 100)]
target_check.sort_values(['distance','fare_amount'], ascending = False)
| key | fare_amount | pickup_datetime | pickup_longitude | pickup_latitude | dropoff_longitude | dropoff_latitude | passenger_count | distance | year | month | date | day_of_week | hour | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1632032 | 2013-04-21 15:13:00 | 11.0 | 2013-04-21 15:13:00 | -74.002510 | 40.734320 | -70.183332 | 40.756540 | 1.0 | 199.922210 | 2013.0 | 4.0 | 21.0 | 6.0 | 15.0 |
| 2811044 | 2012-03-22 08:34:00 | 5.3 | 2012-03-22 08:34:00 | -74.005112 | 40.741367 | -77.816665 | 40.732262 | 1.0 | 199.544089 | 2012.0 | 3.0 | 22.0 | 3.0 | 8.0 |
| 1357154 | 2010-05-11 16:24:42 | 10.9 | 2010-05-11 16:24:42 | -70.961200 | 42.505300 | -73.967621 | 40.762009 | 1.0 | 196.489427 | 2010.0 | 5.0 | 11.0 | 1.0 | 16.0 |
| 4822280 | 2013-09-02 20:28:00 | 8.5 | 2013-09-02 20:28:00 | -73.983740 | 40.734302 | -77.716667 | 40.743877 | 1.0 | 195.421917 | 2013.0 | 9.0 | 2.0 | 0.0 | 20.0 |
| 1738206 | 2013-01-10 14:47:00 | 7.5 | 2013-01-10 14:47:00 | -77.633333 | 40.784112 | -73.967712 | 40.768627 | 2.0 | 191.793184 | 2013.0 | 1.0 | 10.0 | 3.0 | 14.0 |
| ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
| 1926509 | 2011-03-11 21:45:31 | 49.8 | 2011-03-11 21:45:31 | -73.963062 | 39.629601 | -75.342620 | 40.643574 | 1.0 | 101.090299 | 2011.0 | 3.0 | 11.0 | 4.0 | 21.0 |
| 3286123 | 2011-03-28 15:43:49 | 49.8 | 2011-03-28 15:43:49 | -75.329236 | 40.645135 | -73.958087 | 39.627681 | 2.0 | 100.938013 | 2011.0 | 3.0 | 28.0 | 0.0 | 15.0 |
| 4507221 | 2014-09-16 04:51:00 | 11.5 | 2014-09-16 04:51:00 | -73.980398 | 40.734552 | -75.468602 | 41.670472 | 1.0 | 100.834201 | 2014.0 | 9.0 | 16.0 | 1.0 | 4.0 |
| 1937753 | 2015-05-08 13:51:46 | 20.5 | 2015-05-08 13:51:46 | -72.063202 | 40.834679 | -73.982452 | 40.772621 | 2.0 | 100.473338 | 2015.0 | 5.0 | 8.0 | 4.0 | 13.0 |
| 2234097 | 2011-03-27 21:34:02 | 49.8 | 2011-03-27 21:34:02 | -75.343970 | 40.645350 | -73.933972 | 39.671217 | 1.0 | 100.371781 | 2011.0 | 3.0 | 27.0 | 6.0 | 21.0 |
103 rows × 14 columns
target_check.fare_amount = target_check.apply(lambda x: ((x.distance * 1.56) + 2.5), axis = 1)
df.update(target_check)
After all corrections, correlation of distance and fare amount should be linear and fair
fig, ax = plt.subplots(1, 1, figsize=(16,10))
ax.scatter(x=df.distance, y=df.fare_amount, s=1.5)
ax.set_xlabel('Distance')
ax.set_ylabel('Fare')
ax.set_title('Fare Distribution with relation to distance')
Get the minimum and maximum range of the co-ordinates from the test dataset to plot the graph
bb = (min(test_df.pickup_longitude.min(), test_df.dropoff_longitude.min()),
max(test_df.pickup_longitude.max(), test_df.dropoff_longitude.max()),
min(test_df.pickup_latitude.min(), test_df.dropoff_latitude.min()),
max(test_df.pickup_latitude.max(), test_df.dropoff_latitude.max()))
bb
Function filter the range of pickup and dropoff locations from the training dataset
def filter_range(df, bb):
return (df.pickup_longitude >= bb[0]) & (df.pickup_longitude <= bb[1]) & \
(df.pickup_latitude >= bb[2]) & (df.pickup_latitude <= bb[3]) & \
(df.dropoff_longitude >= bb[0]) & (df.dropoff_longitude <= bb[1]) & \
(df.dropoff_latitude >= bb[2]) & (df.dropoff_latitude <= bb[3])
Plot of non-linear traffic in the city
fig, axs = plt.subplots(1, 2, figsize=(24,12))
idx = filter_range(df, (-74.1, -73.7, 40.6, 40.9))
axs[0].set_title('Pickup Locations')
axs[0].scatter(df[idx].pickup_longitude, df[idx].pickup_latitude, c='r', s=0.01, alpha=0.5)
axs[1].set_title('Dropoff Locations')
axs[1].scatter(df[idx].dropoff_longitude, df[idx].dropoff_latitude, c='b', s=0.01, alpha=0.5)
Correlation map of features
plt.figure(figsize=(15,12))
cor = df.corr()
sns.heatmap(cor, annot=True, cmap=plt.cm.CMRmap_r)
plt.show()
Prepare the test dataset
distance(test_df, 'pickup_latitude', 'pickup_longitude', 'dropoff_latitude', 'dropoff_longitude')
test_df['year'] = test_df.pickup_datetime.dt.year
test_df['month'] = test_df.pickup_datetime.dt.month
test_df['date'] = test_df.pickup_datetime.dt.day
test_df['day_of_week'] = test_df.pickup_datetime.dt.dayofweek
test_df['hour'] = test_df.pickup_datetime.dt.hour
Drop the insignificant variables
df.drop(['key','pickup_datetime'], axis = 1, inplace = True)
test_df.drop(['key','pickup_datetime'], axis = 1, inplace = True)
Convert pandas dataframe to spark dataframe for further modeling
train_df = ps.from_pandas(df)
train_df = train_df.to_spark()
Linear Regression
feature_assembler = VectorAssembler(inputCols=['pickup_longitude', 'dropoff_longitude', 'passenger_count', 'distance', 'year', 'month', 'date'], outputCol="features")
lr = LinearRegression(labelCol="fare_amount")
pipeline = Pipeline(stages=[feature_assembler, lr])
train, test = train_df.randomSplit([0.75, 0.25])
lr_model = pipeline.fit(train)
predictions = lr_model.transform(test)
evaluator = RegressionEvaluator(labelCol= 'fare_amount', predictionCol= 'prediction')
print('RMSE:', evaluator.evaluate(predictions, {evaluator.metricName: "rmse"}))
print('R-squared:', evaluator.evaluate(predictions, {evaluator.metricName: "r2"}))
Decision Tree
feature_assembler = VectorAssembler(inputCols=['pickup_longitude', 'dropoff_longitude', 'passenger_count', 'distance', 'year', 'month', 'day_of_week', 'hour'], outputCol="features")
dt = DecisionTreeRegressor(labelCol="fare_amount")
pipeline = Pipeline(stages=[feature_assembler, dt])
train, test = train_df.randomSplit([0.75, 0.25])
dt_model = pipeline.fit(train)
predictions = dt_model.transform(test)
evaluator = RegressionEvaluator(labelCol= 'fare_amount', predictionCol= 'prediction')
print('RMSE:', evaluator.evaluate(predictions, {evaluator.metricName: "rmse"}))
print('R-squared:', evaluator.evaluate(predictions, {evaluator.metricName: "r2"}))
Random Forest
feature_assembler = VectorAssembler(inputCols=['pickup_longitude', 'pickup_latitude', 'dropoff_longitude', 'dropoff_latitude', 'passenger_count', 'distance', 'year', 'month', 'date', 'hour'], outputCol="features")
rf = RandomForestRegressor(labelCol="fare_amount")
pipeline = Pipeline(stages=[feature_assembler, rf])
train, test = train_df.randomSplit([0.75, 0.25])
rf_model = pipeline.fit(train)
predictions = rf_model.transform(test)
evaluator = RegressionEvaluator(labelCol= 'fare_amount', predictionCol= 'prediction')
print('RMSE:', evaluator.evaluate(predictions, {evaluator.metricName: "rmse"}))
print('R-squared:', evaluator.evaluate(predictions, {evaluator.metricName: "r2"}))
Gradient Boosting
feature_assembler = VectorAssembler(inputCols=['pickup_longitude', 'pickup_latitude', 'dropoff_longitude', 'dropoff_latitude', 'passenger_count', 'distance', 'year', 'month', 'date', 'day_of_week'], outputCol="features")
gbr = GBTRegressor(labelCol="fare_amount")
pipeline = Pipeline(stages=[feature_assembler, gbr])
train, test = train_df.randomSplit([0.75, 0.25])
gbr_model = pipeline.fit(train)
predictions = gbr_model.transform(test)
evaluator = RegressionEvaluator(labelCol= 'fare_amount', predictionCol= 'prediction')
print('RMSE:', evaluator.evaluate(predictions, {evaluator.metricName: "rmse"}))
print('R-squared:', evaluator.evaluate(predictions, {evaluator.metricName: "r2"}))
Create or load an Azure ML workspace
It will load a workspace or create a new one if it does not exist.
workspace_name = "fare-prediction"
workspace_location = "eastus"
resource_group = "NYC_Price_Prediction"
subscription_id = "75b2e7f9-9c16-4ece-9685-e7db922c1b62"
authentication = InteractiveLoginAuthentication(tenant_id = "bc7e12a8-5234-4447-9371-44fc05a1d39c")
workspace = Workspace.create(name = workspace_name,
location = workspace_location,
resource_group = resource_group,
subscription_id = subscription_id,
auth = authentication,
exist_ok = True)
Train the best performance model on the dataset using MLflow to log metrics, parameters, artifacts and model
def fare_training(df, alpha, n_estimators):
warnings.filterwarnings("ignore")
if float(alpha) is None:
alpha = 0.9
else:
alpha = float(alpha)
if int(n_estimators) is None:
n_estimators = 100
else:
n_estimators = int(n_estimators)
np.random.seed(42)
train, test = train_test_split(df)
X_train = train.drop(["fare_amount"], axis=1)
X_test = test.drop(["fare_amount"], axis=1)
y_train = train[["fare_amount"]]
y_test = test[["fare_amount"]]
def evaluation_metrics(true, pred):
return np.sqrt(mean_squared_error(true, pred)), mean_absolute_error(true, pred), r2_score(true, pred)
with mlflow.start_run() as run:
gbr = GradientBoostingRegressor(alpha=alpha, n_estimators = n_estimators, random_state = 42)
gbr.fit(X_train, y_train)
predictions = gbr.predict(X_test)
(rmse, mae, r2) = evaluation_metrics(y_test, predictions)
print("GradientBoostingRegressor(alpha=%f, n_estimators=%f):" % (alpha, n_estimators))
print(" RMSE: %s" % rmse)
print(" MAE: %s" % mae)
print(" R2 Score: %s" % r2)
mlflow.log_param("alpha", alpha)
mlflow.log_param("n_estimators", n_estimators)
mlflow.log_metric("rmse", rmse)
mlflow.log_metric("mae", mae)
mlflow.log_metric("r2", r2)
mlflow.sklearn.log_model(gbr, "model")
temp = int(random()*1000)
path = "/dbfs/mlflow/fare_test/model-%f-%f-%f" % (alpha, n_estimators, temp)
mlflow.sklearn.save_model(gbr, path)
run_id = run.info.run_id
print('Run ID: ', run_id)
model_uri = "runs:/" + run_id + "/model"
print('model_uri: ', model_uri)
return run_id, model_uri
run_id, model_uri = fare_training(df, 0.01, 80)
Create a container image for trained model to deploy in Azure Container Instances(ACI) using MLflow
Further as per the requirement container image can be deployed to ACI for staging which serve as REST endpoint and Azure Kubernetes Service(AKS) for production.
model_image, azure_model = mlflow.azureml.build_image(model_uri = model_uri,
workspace = workspace,
model_name = "gbr-model",
image_name = "gbr-model",
description="Gradient Boosting Regressor for fare prediction",
synchronous=False)
model_image.wait_for_creation(show_output=True)